Forum Discussion
Solved
Get Next Larger DateTime
Hi all, How to get next larger datetime from another table? I have tblStart and tblEnd I am trying to build a new table so I cna use the datetime fields to calculate elapsed time. Problem i...
Hi,
Write this calculated column formula in the tblHold Table
=calculate(min(tblRelease[date_time]),filter(tblRelease,tblRelease[work_order_id]=earlier(tblHold[work_order_id])&&tblRelease[date_time]>earlier(tblHold[date_time])))
Hope this helps.
Thanks Ashish,
Works perfectly!
Thanks,
-w
You are welcome.