I have in a query a complex formula that has -
"Iif(date=#1/1/2013#,true,false)"
and my output in my formula is correct.
But I need to make the year = a variable not a constant or omit the year entirely.
I tried Iif(date=#1/1/Year(Date)#,true,false) and it gives me an error invalid date format.
I tried Iif(date=#1/1#, true, false) omitting the year and it gives the error invalid date format.
I really don't even need the year. I just need a Iif statement if the date is 1/1 then do this.
But I can't figure out a simple solution, yet it seems pretty simple.
Anyone with an idea???