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?
I would suggest that you provide a sample by uploading a spreadsheet with your current data scheme. This way will able to determine what the best approach would be to your problem.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Here's a simplified version of my spreadsheet. I need to sort by date, but this sorts the date column alphabetically, not by the actual date.
I think you'll need to convert those entries to real dates so you can sort them.
Try this formula in a helper column, format the result as you want and then sort on it.
Formula:
Please Login or Register to view this content.
If posting code please use code tags, see here.
If there's no direct way to change the date formula so it can sort, this formula does the trick.
Thanks! Problem solved.
You could do something with code but it would probably just be replicating the formula.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks