I am calculating a date difference (Calendar Days: DateDiff("d",[EnrollmentDate],[WithdrawalDate]).
Then trying to adjust for weekends and holidays:
Class Days: IIf([EnrollmentDate] Between #8/24/2014# And #10/1/2014#,[Calendar Days]-11),IIF([EnrollmentDate]Between#08/24/2014#and#11/01/2014#,[Calendar Days]-21))
If I run the first IIF it works fine, but as soon as I add the nested IIF I get:
Expression contains invalid syntax or enclose text in quotes.
If I run the second IIF as stand alone it too works fine.
What am I missing in the nesting?