Forum Discussion

UncleLewis's avatar
UncleLewis
Icon for Responsive Resident rankResponsive Resident
4 years ago
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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    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.

UncleLewis's avatar
UncleLewis
Icon for Responsive Resident rankResponsive Resident
4 years ago

Thanks Ashish,

 

Works perfectly!

Thanks,
-w

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

You are welcome.