Habit-Tracker: Display the last X days and the future Y days in table

[Gewerd-Strauss]

Hello,

I am slowly starting to set up a habit tracker now, and I am trying to get it restricted to show a specific date-range.
My daily-notes are created in the folder 300 Personal/301 DailyNotes/[Year]/[Month_Number Month_Name]/[dd.MM.yyyy].

Example: 300 Personal/301 DailyNotes/2022/09 September/09.09.2022.md
It should be noted that I create these files usually 5-12 days in advance because I note down rough working schedules and notable events ahead of time.

I now want to create two habit trackers to track a specific timeframe.

1. One should display data for all files of the current month
2. One should display data for the range from today-X days up to today+Y days

I could however not figure out how to get this WHERE-condition to work properly.

Thank you,
Sincerely,
~Gw

[mnvwvnm]

To start you need to define where you get the right date value:

• if you create the files in advance, creation date isn't a viable date;
• the format of your title (dd.MM.yyyy) isn't a recognized iso date format - you need to use yyyy-MM-dd to have an implicit date metadata -> file.day
• if you don't want to change the title format, then you need to create in each daily note a field with the true date in iso format.

Then, with a valid date as reference, you can achieve what you want (but that is a second step) 🙂

[Gewerd-Strauss]

Hmm, alright thank you. I'll change my template to include an iso-conforming field to use.

[Gewerd-Strauss]

This worked pretty well, thank you.

[Deus333]

I want to filter tasks that are in daynote

TASK
FROM #journal 
WHERE file.day("yyyy-mm-dd")

Why this doesn't work, and what should I do?