How to compare time in dataview

Things I have tried

my query got empty table:

table 
from #test
where number(Durations.D230209.minutes)=120 

sample file:

---
Durations:
- D230209: 2hrs
---

# title
#test

What I’m trying to do

select file where Durations.D230209 equals 2hrs

Hi @xshuai1006 , your YAML has an issue – the dash before D230209 makes it a list item, not a key-value pair. Your query worked in my vault by removing the dash:

---
Durations:
  D230209: 2hrs
---

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.