I am trying to use the Auctiva CSV Reports (BETA), but have a problem sorting by date. The generated format for this field is "Weekday, day, year, time AM/PM", however Excel does not recognize that as a date format, so I am unable to sort on that column. It is not even possible to cast those as a date by formatting the cells. An attempt to sort by date doesn't work, it will give a string sort, with all the Monday values first, etc. What I am doing now is a search and replace for each of the 7 weekday names, which is not efficient.
So, unless someone can tell me what I am missing here, I guess this is a suggestion to allow that field to be formatted by the user. Come to think of it, even without the weekday having a fixed format is problematic because some countries use a different date format, and month names are not the same.
Original Post