Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
Maybe this is what you want
If(
not IsNull([Started]),"NA",
[Active Dif Calc]>7,"LT7",
[Active Dif Calc]>1,"LT1",
Now()-[Start Date] < Hours(24), "E1")
If(
not IsNull([Started]),"NA",
[Active Dif Calc]>7,"LT7",
[Active Dif Calc]>1,"LT1",
Now()-[Start Date] < Hours(24), "E1")
KatrinaE
7 years agoQrew Cadet
(ToDays(ToDate([Started]) - ToDate([Start])))