text date to date format
I have column filled with:
'Apr 3 2005 4:37PM
And I need to change it to:
04/03/05 4:37PM
How do I get a textual date column into a sortable date/time column? I'm
having problems because it sorts everything by alpha then numeric. For
example, I have "Apr 15, 2005" before "Aug 10, 2003". I need to get these
sorted by year, month, day...not alphabetically. Thanks in advance for your
help!
|