Crystal Reports Formatting text as a date

Writing Code
Crystal Reports Forum : Crystal Reports .NET 2003 : Writing Code

Topic: Formatting text as a date

Author	Message
stevetothink Newbie Joined: 18 Oct 2010 Online Status: Offline Posts: 37	Topic: Formatting text as a date Posted: 19 May 2014 at 8:28am
	I have a text field storing dates, such as 06/01/2016. How can I get crystal to convert this text field to an actual date format of MM/DD/YYYY when running a report? Also - is it possible to code crystal so it recognized 6/1/14 as MM/DD/YYYY? Thanks, Steve
	IP Logged

stevetothink Newbie Joined: 18 Oct 2010 Online Status: Offline Posts: 37	Posted: 19 May 2014 at 10:18am
	I fished my wish - found it by searching online a little more extensively. If IsDate ({table.DateField}) Then CDate ({table.DateField}) Else Date (0, 0, 0);
	IP Logged

jessicacyrus1 Newbie Joined: 09 Jun 2016 Online Status: Offline Posts: 1	Posted: 15 Jun 2016 at 1:28am
	Thank you for posting the answer it will be help full to me and many others also. because I also Don't have Idea about it.
	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.031 seconds.