03-16-2011 12:51 PM
I'm running ACT version 2010 Version 12.0.409.0, Hotfix 3. I have a "date" field in which I have contract end dates. I enter the information in the standard MM/DD/YEAR format. When I sort by this field in my "list view," it doesn't sort by year first. It sorts by month, then day, then year.
I have figured out that when you export the list to Excel, Excel recognizes that the data is a date and sorts by year/month/day (even though it displays as month/day/year). Why isn't ACT capable of doing this?
I have tried to see if there is an option I am missing when I create a new field that is in the "date" format, but don't see an option on how to specify how to sort the date.
Anyone figure this out yet? It's too hard to read the format that would make the field sort properly (2012/12/31). Is it fixed in a newer version?
Thanks for your help!
03-16-2011 01:33 PM
The data type for the field is character so you get a character sort. You need to change the field data type to date and then it will sort as dates.. You can check your field in the layout, if the dropdown shows a calendar then it's a date field.