View Single Post
  #1  
Old April 20th, 2010, 04:31 PM posted to microsoft.public.access.gettingstarted
Yappy
external usenet poster
 
Posts: 7
Default 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!