How to query tasks inside daily note and show only tasks due or created on the day of that note?

[serhioromano]

Hello.

I am new to Obsidian and just learning. I installed tasks and dataview plugins. I have a single Tasks.md file where I have all my tasks. I created requiring everyday tasks. Now I am creating template for Daily note that would show those tasks. So every dayly note should show only tasks of that day created by reccuring.

This is what I use to show tasks of the day

```dataview
TASK 
WHERE !completed 
AND contains(tags, "#саморазвитие")
AND created = date(today)
SORT created ASC

And it works fine. But I want to show only tasks of that day, daily note was created. What whoulf i write instead of today?

Actually I want to use tasks query

tasks
due on today
tags include саморазвитие

This works but nothing else. I tried <% tp.date.now("YYYY-MM-DD", 0, tp.file.title, "DD MMM YYYY") %> and {{date:YYYY-MM-DD}} all I could find but nothing works.

[DavidK]

I’m not totally sure if this will work but you could try:

TASK 
WHERE !completed 
AND contains(tags, "#саморазвитие")
AND created = date(today)
SORT rows.file.ctime ASC

[serhioromano]

That on every daily note shows tasks of today regardles of date of that daily note.

[dawni]

If created is a date (without time) and you also have a created value in each daily note, then try this Dataview query:

TASK 
WHERE !completed 
AND contains(tags, "#саморазвитие")
AND created = this.created
SORT created ASC

If created is a datetime, then change the last AND to:

AND striptime(created) = this.created

But if created is not in the daily note, then where is the daily note’s date (e.g., in the note name, in another property) and what’s the full format (e.g., “daily note 2025-09-16”)?

[serhioromano]

My daily note format is DD MMM YYYY and this is the name of the file 23 Sep 2025.

[dawni]

Tasks created on the day of your daily note:

TASK 
WHERE !completed
AND contains(tags, "#саморазвитие")
AND created = date(this.file.name, "dd MMM yyyy")
SORT created ASC

For tasks due that day, change created to due (or whatever property name you’re using for due).

[serhioromano]

Perfect. That works. Is it possible to do the same with tasks query?

[dawni]

I would think so but don’t know much about the Tasks plugin. Hopefully someone who uses it can help.