View Single Post
  #1   Report Post  
Kyli
 
Posts: n/a
Default 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!