In SmartView Monitor, SAM rules list their expiration dates as '%R %B %d, %Y'. This expands to "hour:minute monthName zeroPaddedDayOfMonth, yearWithCentury". Sorting on this column is done in strict alphabetical order, which results in strange orderings:
09:47 April 03, 2018
09:52 March 31, 2018
10:04 April 04, 2018
10:07 April 02, 2018
I suspect nobody has ever wanted this ordering of expiration dates.
Please change the display of the expiration date to ISO 8601 format: '%FT%R', which expands to 'yearWithCentury-month-dayOfMonth', a letter T, then 'hour:minute', all with zero-padding as needed. This should cause them to sort properly with no added sorting logic.
Bookmarks