Dataview: converting "ddd MMM DD YYYY" date format string to date object

[tomshreds]

Hi, I use the following format for my daily notes ddd MMM DD YYYY ie. Sun Mar 09 2025

I’m trying to get all notes created and changed for the day just like this post but for some reason date(this.file.name) doesn’t seem to work with this format.

table without id
file.link as Note, file.mtime as Modified
where file.cday = date(this.file.name) AND file.mday = date(this.file.name)
sort file.mtime DESC
limit 15

I also have properties that look like these:

updated_at: 2025-03-09 07:57
created_at: 2025-03-09 06:00

which I also tried to use in the same way to no avail.

Any idea why this doesn’t work? These formats seems to work with normal javascript Date() objects and with Momentjs which I think Dataview uses for its dates?

In the best scenario, I would be able to use the title of the note and convert it to a date in order to use it with dataview. Any suggestion?

Thanks!

[FsOver2]

When your date format doesn’t follow the default YYYY-MM-DD format, you can specifiy the format in the date(text, format) command. Dataview used luxon token format for it’s dates, so your note format would be specified as : "ccc LLL dd yyyy"

```dataview
table without id
file.link as Note, file.mtime as Modified
where file.cday = date(this.file.name,"ccc LLL dd yyyy") AND file.mday = date(this.file.name,"ccc LLL dd yyyy")
sort file.mtime DESC
limit 15
```

Functions - Dataview

luxon - Immutable date wrapper

[tomshreds]

You just made me realize I had misread the documentation and had forgotten to pass a format to date()! Thanks so much, everything works now

[FsOver2]

I’m glad it’s working for you!

As far as date( ) goes, you only need the format string if the object isn’t in standard ISO format, so you might not have read the documentation wrong. You just missed that nuisance.