How to query tasks by due date with internal link format?

[edentsai]

When a task use timestamp with link (e.g. [completion:: [[2022-12-01]]] or [due:: [[2022-11-30]]),
how can I query these tasks with date() function?

I tried the following conditions are not working:

• TASK ... WHERE due <= date("2022-12-01")
• TASK ... WHERE due <= date([[2022-12-01]])
• TASK ... WHERE due <= date("[[2022-12-01]]")

Markdown Sample

---
tags:
  - "query-date-with-link-demo"
---

## Tasks

- [ ] First Task [due:: [[2022-12-01]]]
- [ ] Second Task [due:: [[2022-12-05]]]

## Dataview Query

Note: `WHERE due <= date("[[2022-12-01]]")` not works.

```dataview
TASK
FROM #query-date-with-link-demo
WHERE due <= date("[[2022-12-01]]")
```

Dataview Query Result

References

• Allow completion tracking to stamp the task with link to daily note instead of just date #1245

Thanks

[edentsai]

I found the resolution is use date(due) to transform the link [[2022-12-01]] to DateTime:

  TASK
  FROM #query-date-with-link-demo
- WHERE due <= date("2022-12-01")
+ WHERE date(due) <= date("2022-12-01")

[AB1908]

Cool, how'd you do this cool markup thing tho?

[edentsai]

Do you mean the code block with diff syntax in Markdown?

here is the raw Markdown:

```diff
  TASK
  FROM #query-date-with-link-demo
- WHERE due <= date("2022-12-01")
+ WHERE date(due) <= date("2022-12-01")
```

[AB1908]

Thanks!