Forum Discussion
Hours Elapsed based on todays date
Hi Experts
Not sure if the following mesure will give me what i need ( i am not after the average time, but actual time). I am trying work our the number of hours that have elapsed based on todays date and based on the created on date in the sample data below...
Measure = Averagex(
T,
VAR created_ = T(Created on)
VAR Now_ = Now()
Var SecondsPerHour = 60 * 60
Return
DateDiff(Second, Created_,Now_)
| Record ID | Created On | Elapsed Time Hours |
| 1 | 4/7/2021 07:10:56am | 98.1 |
| 2 | 30/4/2021 5:55:10pm | 32.4 |
| 3 | 5/1/2021 2:42am | 8.3 |
Anonymous , seem fine, A measure like
Averagex(Table, datediff([Created On], now(), second)/3600.0 )
or a column
datediff([Created On], now(), second)/360.0
1 Reply
- amitchandak
Super User
Anonymous , seem fine, A measure like
Averagex(Table, datediff([Created On], now(), second)/3600.0 )
or a column
datediff([Created On], now(), second)/360.0