Forum Discussion

WardHolberg's avatar
WardHolberg
Qrew Trainee
8 years ago

Syntax error on IF statement in date formula. HELP

I am trying to use a date formula to calculate a date if a checkbox is unchecked or allow a user to enter a date if a checkbox is checked. IF([Verification Extension] = 1, Date(yyyy, mm, dd), [Actu...
Ask about Quickbase functionality
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Try this

IF([Verification Extension] = true, [Actual Date for Corrective action Implemented]+Days(14))

But what result do you want if the [Verification Extension] is not true?