Date string conversion

[rhoneyfi]

I'm pretty new with Crystal, so this is probably a basic question.

I have a date/time field that is classified as a string:

ex: "04/14/2003 02:15:52" . I simply want to convert this into a field that is acutally classified as a date/time field so that I can do a couple calculations. I know there is a formula somewhere....

I tried the DTStoDateTime function, but it only returned the time, but not the date.

Thanks for any info

 

[synapsevampire]

Try:

cdatetime("04/14/2003 02:15:52&quot

Replacing the datetime with your field.

-k