I have a field called 'Arrival Date' in Analysis Workbench taken in dd/mm/yyyy format. It's not a proper date object, just a string, so when I try to sort by Arrival Date date you can imagine the screwy results I get.
If I could reformat to yyyy-mm-dd that would be much better. Is there any way I can do that without manually typing in all the new dates?
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.