I’ve got a date variable that I use in a view. In the date column’s settings, if I have the settings set to “Sort - Ascending - Standard” the column sorts correctly by date. However, if I select “Click on column header to sort” … the results are sorted as if they were text, and the “year” in the date is disregarded. For example it would sort 01/01/2010 then 01/01/2011 and the 02/01/2009.
Why does the sort work correctly in one case (sort ascending standard) and not work properly when “click on column header” is used?
I can certainly kludge together a fix by parsing the date etc … but I’m wondering if there is a better way to get the “click on column header” to work the way it SEEMS it should.