How to compare time in dataview

Things I have tried

my query got empty table:

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

sample file:

- D230209: 2hrs

# title

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:

  D230209: 2hrs

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