Expression using Iif with dates
The following expression results in an error telling me that I may have
entered an operand without an operator. What ami I missing?
Iif ([Certification Frequency] = “Annual”, DateAdd (“yyyy”, 1, Certification
Date]), Iif ([Certification Frequency] = “Monthly”, DateAdd (“m”, 1,
Certification Date]), Iif ([Certification Frequency] = “Quarterly”, DateAdd
(“q”, 1, Certification Date]), Iif ([Certification Frequency] =
“Semi-Annual”, DateAdd (“m”, 6, Certification Date]), [Certification Date]))))
Expression entered has an invalid syntax….you may have entered an operand
without an operator
Thanks for your help!
|