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
WardHolberg's avatar
WardHolberg
Qrew Trainee
8 years ago
No.  I can not enter the date manually.  It will only calculate.  Here is what I have now and continue to get a syntax error. 

If([Verification Extension] = false, [Actual Date for Corrective action Implemented]+Days(14),Date(yyyy,mm,dd))

It works fine if the ([Verification Extension] checkbox is unchecked, but does not allow me to enter a date manually if I only use the formula:

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