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?

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

Post Reply

Post New Topic

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

This page was generated in 0.016 seconds.