Sorting by frontmatter date?

[notflip]

I'm trying to build a query to get my weight entries from my Journal folder, with the following query the dates are not sorted by date, but by alphabet.

My data in a Journal page looks like this

---
date: 02-11-2021
weight: 67.7
---
# 02-11-2021

const obsData = dv.pages('"Journal/Daily"').sort(p => p.date)

I tried using the dv.date() method to wrap the dates but that is not returning anything

const obsData = dv.pages('"Journal/Daily"').sort(p => dv.date(p.date))

Does anyone know how to achieve this?

[blacksmithgu]

Dataview parses dates in ISO style, meaning YYYY-MM-DD; other date formats are just considered to be regular strings and sorted alphabetically.

You can either change your frontmatter dates to use the ISO style, or you can alternatively use luxon DateTime.fromFormat() to parse the dates yourself, which should then sort them properly.

[notflip]

So the DateTime object from luxon is readily available to use just like that?

[blacksmithgu]

You may need to access it via let DateTime = dv.luxon.DateTime, but yes, you can use any DateTime features. Dataview dates are just raw datetimes.