Manually Entered Date Ordering Issue
Whenever I manually enter a date range, the range gets reversed so that the lowest date is on top and the greatest date is on the bottom. There is one problem with this. It looks at the month only. I think that it is sorting alphanumerically. I've attached a video that I captured using Jing. It only lets me save as .swf and the only way I could play it back is by using Internet Explorer. If you cannot view it, this is what happens:
I enter in the date range in the following order:
05/31/2016 - 08/01/2015
The logic is supposed to be designed to switch 05/31/2016 with 08/01/2015 because 08/01/2015 is older (less) than 05/31/2016 but it doesn't. Since 08 is greater than 05 it keeps the current order and when I run the report I receive an error message: Max value must be greater than Min value.
If I enter the reverse:
08/01/2015 - 05/31/2016
Then the two dates are switched because 05 < 08 even though the 05/31/2016 > 08/01/2015. This will again result in the previously mentioned error message.