How to convert string field to date field

Hi,

       I have a field for date in string format in database.I stored data in db as "07/22/2011 12:00:00 AM" which is string type. Now i want to convert stiring into date format to be displayed in crystal report as "07/22/2011". [MM/dd/yyyy]

Thanks in advance.

Hi,

Thank you, once agian for your question,

date format is tricky part in the crystal report. here is solution for you,

ToText({MYFIELDNAME }, "MM/dd/yyyy")

thank you