Changing strings to dates 1

[paula]

I'm working with a report based on a SQL view set up by one of our 'experts'. For reasons only known to himself, one of the fields (MOD_DATE) has been created as a string (DD/MM/YY). The appearance on the report is suitable for my needs (date is in English format), but obviously can't be sorted etc. as it's a string.

Does anyone have any ideas on how to change this to a true date, please?

 

[kenhamady]

In the FAQ area is a FAQ I wrote on common formulas. It includes one for string dates to Dates. You might have to modify it a bit because it assumes mm/dd/yyyy. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[paula]

Many thanks - I'd looked at the similar formula on the Crystal Knowledge base, but hadn't been able to turn it around to my needs successfully.

Yours was far clearer.

Thanks again,

Paula