Forum Discussion

RachelJones's avatar
RachelJones
Qrew Cadet
8 years ago

Syntax error on multiple If statements with variables

I cannot figure out why I have a syntax error in my formula. Everything seems to be correct. I am trying to calculate the due date/time based on the start date time field [Date Time]. I have to use...
Errors
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
:)

Right, I missed that ...

If(
$isSunday,ToTimestamp(ToDate(WorkdayAdd(ToWorkDate(ToDate([Date Time]))),2),ToTimeOfDay("8 pm"))),

$isSaturday,ToTimestamp(ToDate(WorkdayAdd(ToWorkDate(ToDate([Date Time]))),3),ToTimeOfDay("8 pm"))),

$isFriday and $isFridayEightPM,ToTimestamp(ToDate(WorkdayAdd(ToWorkDate(ToDate([Date Time]))),4),ToTimeOfDay("8 pm")),

$isFriday and not $isFridayEightPM,  ToTimestamp(ToDate(WorkdayAdd(ToWorkDate(ToDate([Date Time])),2)),ToTimeOfDay([Date Time])))
)

There may be unbalanced brackets.  I did not try to reconcile the closing ))) at the end of each line.

Note that with Quick Base, unlike Excel, you do not need to next your IFs.  You can just start with one IF( and then list all your tests and results below in sequence.

That last ) at the end by itself is the closing to the beginning ( of the IF.