How Do You Sort By a Date Property?

[Noelle_Devoe]

I’m attempting to create a query that returns all blocks tagged #meeting and then sort it by the property scheduled, which is a linked date page created using the date picker. The problem I’m running into is that when I sort the table by the scheduled property in the table, it sorts by alphabetical order rather than the reverse-chronological date.

Below is my query and the resulting table when I sort it. Can anyone help me figure out what I’m doing wrong here? Thanks!

#+BEGIN_QUERY
{:title [:h3 "📆 Upcoming Meetings"]
 :query (and [[meeting]] (not [[Templates]]) (property :scheduled) (sort-by))
 :result-transform (fn [result] (sort-by (fn [r] (get r :block/content)) result))
 :group-by-page? false
 :breadcrumb-show? false}
#+END_QUERY

[Siferiax]

See the example in this topic to get the desired outcome.

Query & sort for pages with date:: property

Hi, I searched the forums and asked this already in the Discord, but maybe somebody here can help. I would like to get a list of events, sorted by date (ideally, excluding past events). All events are individual pages within the namespace “event”, page name: "event/my first event ". The date is set in the page property date, e.g. date:: [[Nov 4th, 2023]] Any help appeciated! Thanks!