I need to sort a sheet by date and have it sort by year first and then by month and day. My goal is to delete everything before the current year. Just doing a sort lumps all of a month together, for instance: June will include 1999 - 2011 and then the list will move to July. I tried a custom date format but couldn't make that work. Any idea?
The problem was I hadn't imported the data correctly - It came from and ASCII file and instead of importing it as a date field I imported it as text and then formatted it to date. I didn't realize that could change the behavior.
Edited by Meaux30, 28 July 2005 - 10:08 AM.