Daily Journal Dataview Question

New to obsidian.

I’m trying to set up my daily journal to have a task list at the top, and then an unfinished task list below.

How do I get my unfinished task list to only show tasks that are less than the current day?

This is what I have so far:


<span style="color:#323232;">
</span><span style="color:#323232;">dataview
</span><span style="color:#323232;">task
</span><span style="color:#323232;">
</span><span style="color:#323232;">from "Daily Notes"
</span><span style="color:#323232;">
</span><span style="color:#323232;">WHERE !completed AND text != ""
</span><span style="color:#323232;">
</span>
Arxir,

Assuming a key akin to “deadline”, you could use or adapt the following:

WHERE dateformat(deadline, “yyyy-MM-dd”) <= dateformat(date(today), “yyyy-MM-dd”)

Or work with note creation date:

WHERE dateformat(file.date, “yyyy-MM-dd”) <= dateformat(date(today), “yyyy-MM-dd”)

Instead of “today” use “this.file.name” when working with daily notes as in your case.

To have the list be divided into completed and unfinished, skip the “!completed” and instead use:

SORT completed

Add DESC to reverse order.

Another option would be to have two separate dataview queries. One for completed and one for unfinished tasks.

books,

Great! Thanks. That did it

  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • random
  • uselessserver093
  • Food
  • aaaaaaacccccccce
  • [email protected]
  • test
  • CafeMeta
  • testmag
  • MUD
  • RhythmGameZone
  • RSS
  • dabs
  • Socialism
  • KbinCafe
  • TheResearchGuardian
  • Ask_kbincafe
  • oklahoma
  • feritale
  • SuperSentai
  • KamenRider
  • All magazines
    •