Could someone tell me if they see something off about this expression? I'm using it in an expression. It's giving me a syntax error.
=IIf(Fields!NTFrequency.Value = "Quarterly",IIf((DatePart("m", Now)=1), 9, month(now)-3, IIf((DatePart("m", Now)=1), 12,month(now)-1)))
Thanks, Iris
IIf((DatePart("m", Now)=1), 9, month(now)-3
Don't you need a closing parenthesis here?
|||Yep, that worked!! Then I removed one at the end and no errors.
Thanks,
Iris
|||I get one right every now and again. Too much LISP experience, I guess.|||LOL...I went cross-eyed looking at it. Needed a second set of eyes.
Iris
