Crystal Reports Import CSV: How to specify datetime field?

Data Connectivity

Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity

Topic: Import CSV: How to specify datetime field?

Post Reply

Post New Topic

Author	Message
Tim Wise Newbie Joined: 29 Apr 2008 Location: United States Online Status: Offline Posts: 31	Topic: Import CSV: How to specify datetime field? Posted: 02 May 2008 at 1:42pm
	I'm importing a CSV into Crystal 2008 and I'd like a column to be interpreted as a datetime field. Currently it's being interpreted as a string. I'm specifying the field as standard time XML date time: 2008-04-21T09:01:01.445211. What else can I do to get Crystal to interpret the field as a datetime? Thanks. -- Tim
	-- Tim
	IP Logged


Tim Wise Newbie Joined: 29 Apr 2008 Location: United States Online Status: Offline Posts: 31	Posted: 02 May 2008 at 2:36pm
	I created a Formula field that translates the datetime string from the CSV into a real datetime: DTSToDateTime ({Step0009_001_sap_truncated_csv.End Timestamp})
	-- Tim
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum