I have a time column with the date and time as follows:
2/1/2014 3:32:06 PM(UTC+0)
2/1/2014 5:58:15 AM(UTC+0)
2/1/2014 3:56:49 AM(UTC+0)
1/31/2014 11:59:25 PM(UTC+0)
1/31/2014 6:10:03 PM(UTC+0)
1/31/2014 6:09:56 PM(UTC+0)
10/1/2014 4:15:30 PM(UTC+0)
10/10/2014 12:09:23 PM(UTC+0)
I need to sort my table by date and time. The Time zone is not relevant and can be truncated out of the equation if that makes it easier. I'm lost cause the date and time is not formatted fixed width.
Any help would be greatly appreciated.
Thanks
Jason
Bookmarks