Hi -

I have a very large database (40,000 entries), and one of the columns contains the date with a consistent, but inconvenient format. Here is an Example:

Fri Aug 02 00:24:00 PDT 2013

I need to sort these dates from earliest to most recent, but the custom format I attempted sorts in order from left to right (by day of the week, then month, then day of the month, etc.). The custom date format I used is:

ddd, mmm, dd, hh:mm:ss, yyyy

Am I on the wrong track? How can I sort my rows by date?