Forum Discussion

JordanBeatty1's avatar
JordanBeatty1
Qrew Captain
8 years ago

No Error In Formula Syntax Though Field Is Empty

I'm using the following formula: If(DayOfWeek([Date of Injury])=6, [Date of Injury] + Days(11) - Today(), DayOfWeek([Date of Injury])=0, [Date of Injury] + Days(10) - Today(), [Date of Injury] + ...
Formulas and functions
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Then wrap the whole thing in "ToDays" and see if it works

ToDays(
If(DayOfWeek([Date of Injury])=6, [Date of Injury] + Days(11) - Today(), 
DayOfWeek([Date of Injury])=0, [Date of Injury] + Days(10) - Today(),

[Date of Injury] + Days(9) - Today())

)