Sorting query results in the table view

Questions & Help Queries
,
1

I use a query to create a table overview of events with dates. dates were picked with the date picker. if I try to sort the data column ascending or descending, it just never sorts correctly.

image
image

Does anyone know why this is and how to fix it?

2
  • Why this is:
    • Column sorting is string-based.
      • In your case, it sorts based on the names of the months.
  • How to fix it:
    • Should either:
      • Change the date-format to year/month/date.
      • Perform the sorting within an advanced query.
1 Like
3

thanks!
as the date picker is a native logseq function, wouldnt it make sense to arrange it from that side?

4

Many things could make sense, but someone has to write the respective code, because for the computer they are all the same.