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:


dataview
task

from "Daily Notes"

WHERE !completed AND text != ""

5 comments

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.
- Great! Thanks. That did it
You're better using the tasks plugin and a tasks code block for that.
- Why's that?
  
  It's easier to work with if all you're working with is tasks.