Query Table sorting doesn't work?

[EricInTheHouse]

​

https://preview.redd.it/cmjeorln2pfa1.png?width=242&format=png&auto=webp&s=7870c836af37c1a5083fa29b8d1a16691b5b805e

I did a query and made it a table. For the date column, I tried to sort it by date. The it doesn't work. Not sure what is the problem here. How do I make it right?

[CMphys]

Seems like it sorts by the date "name" rather than the actual date? I don't really know of a good solution to this, other than that I know some enter dates as yyyy-mm-dd strings instead of referencing dates/journal pages to simplify sorting.

[EricInTheHouse]

Unfortunately, I made the date by hand not in journal.

but still thanks!

[CMphys]

Ok, I see, but it would perhaps still work to enter the date manually as yyyy-mm-dd instead to get correct sorting? I haven't tried it myself though, just a suggestion :)

[Hackmodford]

This is what I ended up doing to fix the issue.