I am trying to sort my data by date, but it is displaying incorrectly. When I sort by date, it seems to sort the dates numerically instead of by the date. For example, it's displaying descending dates in order of 9/9/17, 9/9/16, 9/9/15, etc. instead of 9/9/17, 9/8/17/, 9/7/17, etc. See the attached screenshot for a visual. Where am I going wrong in my sorting?
4 个回答
Hi
The "Report Date" you are sorting on is a String not a date - you have several dates to choose from or yhou need to convert the "Report Date" to an actual date
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
