Math with Date&Time in Dataview

Help
1

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?

2

Along these lines?

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

### dataview query
```dataview
TABLE WITHOUT ID
	time2 - time1 as Duration
FROM 
	#durationtest
```

date and time duration
date and time duration1644×734 85.4 KB

1 Like
3

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

1 Like
4

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