Changing data type from string to date?

[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]

See the FAQ in the general forum. Ken Hamady

http://www.kenhamady.com/

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