When I attempt to sort on date, the sorting does not work correctly.
I have a custom field called "start date", and it is of type "date". So when sorting from first to last, it sorts correctly for the month portion of the date field, but the day field does not sort properly. For instance, 3 shopping cart items could have dates of 5/2/2012, 5/18/2012, and 5/19/2012, but when sorted, it displays as 5/18/2012, 5/19/2012, 5/2/2012. The sorting algorithm thinks that 5/2/2012 if after 5/19/2012 since it thinks that "2" is greater than "19" (it thinks the 2 should come after 19).
For URL example see
www.rocksolidresults.com/nhcrafts/course...ting&Itemid=561&cid=
Is there a fix for this?
Thank you for your help.