Best way to get a string date as a date object

[mantleg]

I have a date stored as a string in the format mm/dd/yyyy.
What is the easiest way to get this date converted to a datetime object so i can include it in the datediff function.

also what is the method i should use to return a mm/dd/yyyy string back from the datatime object

 

[chrissie1]

cdate(stringvar)
or 
cdate("mm/dd/yyyy")

and

datetimevar.tostring

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
What a wonderfull world - Louis armstrong