We're trying to figure out how to sort dates in this format - MM/DD/YEAR. We've tried a number of supposed solutions, but nothing worked.
By default, these numbers are sorted by the month. We're using TP as an event calendar, so in that scenario, the 2013 dates get mixed in with the 2014 dates. So 01/01/2014 comes before 02/01/2013 in the sorted results.
Can you tell us how we can get this working so it sorts by year, then month, then day in the MM/DD/YEAR format?