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?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.