IIF Statement Help

  • Thread starter Thread starter Terrence Carroll
  • Start date Start date
T

Terrence Carroll

I am getting an error messge saying a I am missing a ( or|and I can not
figure out what is wrong. Can you please assist with debugging the following
code:

Test: IIF(Month(Date())>10 AND Month([Contract Info].[Start Date])<3,
Year(Date())+1, Year(Date())

Essentially I want this calculated field to take a look at the current month
and for January and February add one the the current year, otherwise the
field should be the current year
 
you are missing a parenthesis at the very end.

that last parenthesis you have is ending only the Year function, but
you also need to end the iif function.
 
I am getting an error messge saying a I am missing a ( or|and I can not
figure out what is wrong. Can you please assist with debugging the following
code:

Test: IIF(Month(Date())>10 AND Month([Contract Info].[Start Date])<3,
Year(Date())+1, Year(Date())

Essentially I want this calculated field to take a look at the current month
and for January and February add one the the current year, otherwise the
field should be the current year
Click to expand...

What I do in these cases is to read through the expression left to right,
mentally adding 1 for each left parenthesis and subtracting 1 for each right.
If I do this in your expression I end up with +1. You're missing the final
closing parenthesis for the IIF() function.
 
Back
Top