Sorting query results in the table view

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.


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

  • 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.

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

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