Sorting by date sorts dates with no daily note attached last

[Gnopps]

I've got the following dataviewjs-code to show my meetings for a specific project:

let meetings = dv.pages(`"${dv.current().file.folder}" and #meeting`)
meetings = meetings.sort(k => k.date, 'desc')
for (let meeting of meetings){
dv.el("p", "![[" + meeting.file.name + "]]");
}

The meetings files it compares look like this (no other dataview-data in them):

---
tags: meeting, future
---
#### Metadata
Project:: [[XXX]]
Date:: [[2022-08-04]]

However, sometimes the sort is out of order. I noticed that if the date in question has no daily note attached to it, then it will be sorted to be shown last. Any ideas here why that behaviour is?

[AB1908]

You should actually be sorting on the extracted date since date is a Link object and not a DateTime object. When Date is empty, it likely is null and nulls are placed at the end of a sort. See #985. There was also an issue where this functionality changed but can't find that right now.

[Gnopps]

Thanks for your explanation! How do I then sort on the extracted date instead?

[AB1908]

Sorry, I missed this somehow. Assuming you're still stuck, date extraction is tricky here since the link text contains some extra characters in addition to the date (actually has full path to the file).

date.path.split("/").last() should give you the date string and then you can cast it with moment() or DateTime(), whichever suits your fancy.

[Gnopps]

Yes, that worked! Thank you for your help!