Date calculation and comparisons

Not sure if there is already a guide to this.

Formula Durations = (now -createdDate)/60
Response is 02:30:05

i.e 2 hours, 30mins and 05 seconds

I want to use a comparison operator in the filterUI to show a record if Duration > (60mins)

How do I do this ? Seems like I need to do some conversion somewhere but I can’t figure it out.

So do you mean you need to convert that duration to minutes, and compare it to 60 mins?

yes please.

found another post

round((now - creat)*24,2)*60

Thanks for all help


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