How to list notes created inside a certain hour span

Help
1

What I’m trying to do

My work hours are from 2100 until 0600. Using date-based filters cut my work-day notes in half. Can we specify hour ranges in Dataview? I will make the file after midnight.

Things I have tried

Modifying stuff like the following using time components from date format strings:

dataview
List FROM ""
WHERE file.mday = date(today)  AND file.name!=this.file.name
SORT file.mtime asc

to make something like this:

dataview
LIST
FROM ""
WHERE file.cday >= date(this.file.cday) - dur(3 hours) AND file.cday <= date(this.file.cday) + dur(6 hours)
AND file.name != this.file.name
SORT file.mtime asc
2

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.