Sorting by date doesn't work

loopers

When I click the little arrow on the column header of the date, it doesn't really sort it by date. I assume that's because it's a string? For example, after clicking the sorting arrow, this is how the dates show up:

02-03-2022 10:54:20
02-03-2022 11:46:31
07-03-2022 13:50:21 
07-03-2022 13:51:15 
07-03-2022 13:54:52
07-03-2022 14:03:52
07-03-2022 14:04:44
08-03-2022 09:09:02

unsorted at all.

What should I do?

kthorngren

See this datetime sorting blog for the recommended way to sort dates.

Kevin

loopers

thanks. do you know where to place the moment js code when using Yajra with Laravel?

kthorngren

Not specifically but I suspect in the same area you have datatables.js.

Kevin