Hello all... I'm writing a simple query where I'd like to sort the date result in descending order. The date format is mm/dd/yyyy. When the results return, the sort order is only correct for the given year. For example, the result is:
12/15/2010
10/21/2010
08/01/2010
01/17/2011
I need the 2011 date at the top of this list rather than the bottom. This is most likely very simple, but I'm trying to create a calculated field to do it and have not yet been successful... Any help would be much appreciated. Thanks!
12/15/2010
10/21/2010
08/01/2010
01/17/2011
I need the 2011 date at the top of this list rather than the bottom. This is most likely very simple, but I'm trying to create a calculated field to do it and have not yet been successful... Any help would be much appreciated. Thanks!