Writing Code
 Crystal Reports Forum : Crystal Reports .NET 2003 : Writing Code
Message Icon Topic: Formatting text as a date Post Reply Post New Topic
Author Message
stevetothink
Newbie
Newbie


Joined: 18 Oct 2010
Online Status: Offline
Posts: 37
Quote stevetothink Replybullet 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 IP Logged
stevetothink
Newbie
Newbie


Joined: 18 Oct 2010
Online Status: Offline
Posts: 37
Quote stevetothink Replybullet 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 IP Logged
jessicacyrus1
Newbie
Newbie
Avatar

Joined: 09 Jun 2016
Online Status: Offline
Posts: 1
Quote jessicacyrus1 Replybullet 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 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.