Math with Date&Time in Dataview

What I’m trying to do

Enter combined DateTime values in dataview, and do simple math on entered values

Things I have tried

Searched for “Using math on date time values in Dataview”. I’ve tried using formats 2023-03-03, 2023-03-03T10h02m, dataview tables would not calculate.

I want to enter two date&time values and subtract them to get a duration time. Is this possible?

Along these lines?

time1: 2023-03-06T10:55
time2: 2023-03-06T19:33
tags: durationtest
`= this.time2 - this.time1` 

### dataview query
	time2 - time1 as Duration

1 Like

Exactly! Thanks! I was close, but for the life of me could not find the proper format.

1 Like

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