Hi Everyone
What is wrong with this IIf statement?
I get Invalid Syntax error.
Code:Cal: IIf([P]="New,DateAdd("yyyy",1,[PurchaseDate],IIf([P]="1,DateAdd("yyyy",1,[InspectionDate],IIf([P]=2,DateAdd("yyyy",2,[InspectionDate])))
Hi Everyone
What is wrong with this IIf statement?
I get Invalid Syntax error.
Code:Cal: IIf([P]="New,DateAdd("yyyy",1,[PurchaseDate],IIf([P]="1,DateAdd("yyyy",1,[InspectionDate],IIf([P]=2,DateAdd("yyyy",2,[InspectionDate])))
Bracketing and quote errors. Try this
or remove the final IIf and just use thisCode:Cal: IIf([P]="New",DateAdd("yyyy",1,[PurchaseDate]),IIf([P]="1",DateAdd("yyyy",1,[InspectionDate]),IIf([P]="2",DateAdd("yyyy",2,[InspectionDate]))))
Code:Cal: IIf([P]="New",DateAdd("yyyy",1,[PurchaseDate]),IIf([P]="1",DateAdd("yyyy",1,[InspectionDate]),DateAdd("yyyy",2,[InspectionDate])))
Hi Colin
That works
Many thanks