Forum Discussion

manoharvankired's avatar
manoharvankired
Qrew Trainee
2 years ago

How to calculate the number of hours between four date/time fields, excluding weekends

let (   start = ToDate([Start Date]),   end = ToDate([End Date]),   onHoldStart = ToDate([On Hold Start Date]),   onHoldEnd = ToDate([On Hold Stop Date]),   duration = If(     Not(IsNull(start)...
JeffPeterson1's avatar
JeffPeterson1
Qrew Captain

You're using javascript syntax which isn't allowed.   



------------------------------
Jeff Peterson
------------------------------
manoharvankired's avatar
manoharvankired
Qrew Trainee
2 years ago

Hi Jeff,

Could you please help me on this ?

Thanks

Manohar



------------------------------
manohar vankireddy
------------------------------