Sorting by 'last hit' doesn't work for all date formats

[michaelroper]

Sorting redirects or statistics by 'Last Hit' doesn't seem to work properly for me, possibly due to the date format that I use in the admin being dd/mm/yyyy format.

Example of behaviour: https://cl.ly/iIOe

[khalwat]

So it looks like we have two choices:

1. I can force the date / time display into a specific format, and sorting will work

2. I can let you keep the localized date format, and sorting won't work

I'm not sure which is best, but I'm leaning towards #1

[michaelroper]

I'd be happy with option 1, i'd prefer it to work even if the dates look a little wonky.. ;)
Would that just be reformatting the dates on the client side, or how they are actually saved in the DB?

[khalwat]

The dates are just stored as a DateTime which is agnostic about formats. The problem is that I'm using the Craft datetime Twig filter, which outputs a DateTime in your preferred locale format.

Which wouldn't normally be a problem, except that the DataTables script I use for displaying them apparently only understands and parses dates in US and ISO formats.

So we either display the dates in a format that isn't what your locale prefers, or we can't sort them properly. There's a third option that I've used before, but it's hacky, and I want to avoid it.

[michaelroper]

Was just having a look at that DataTables plugin - it does seem to take plugins for sorting dates in different formats (https://datatables.net/plug-ins/sorting/) - how hard would it be to load that in if the date format is dd/mm/yyyy?

[carlcs]

@khalwat DataTables allows to set a data-order attribute.
https://datatables.net/manual/data/orthogonal-data#HTML-5

[khalwat]

@carlcs yeah but I also need to put support in the db records to store this information, so that they are processed in the desired order