String To Date Function

[coolbrian]

How do I convert a string into a purely date format?
Example, I have a field contained "20020904" in string format and would like to convert this into date format?

Any ideas?

 

[Naith]

There's a fair few ways you could do this.

Here's one of many:

WhilePrintingRecords;
StringVar DT := {YourDate};

Date(Mid(DT,1,4)+","+Mid(DT,5,2)+","+Mid(DT,7,2))

All the best,

Naith

 

[emcevoy]

Hi

Another way you can do this is to use the DTSToDate() function. You can find information on using this and other date functions in the crystal technical document at the following link

http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr567_datetimefunctions.pdf

Hope this helps Eileen McEvoy
Crystal Reports Consultant and Trainer

http://www.crystalconsulting.ca

emcevoy@crystalconsulting.ca

 

[dgillz]

If this field is a number:

NumberToDate({yourField})

If it is a string:

NumberToDate(ToNumber({YourField}))

NumbertoDate() is available on the Crystal Decisions website as a download. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com