How can IIF Statement bring false statement?

I have this statement (below) that works if the condition is true but if its false its not returning what I would like for it to.

Please Login or Register  to view this content.

Not sure what I missed.

You've exceeded the allowable limit for nested IIF statements (7).

Try using a Switch statement within an Iif statement.

Formula:

Please Login or Register  to view this content.

What you could do is set up a small table with 2 fields STE CODE and Years.

The STE CODE field would be populated by the various values "21", "42" etc and the Years field with the corresponding no of years to add.

Then you could use DLookUp to retrieve the no of years to use in the DateAdd.

I've got a feeling that might not be good practice but it should work.

It would also be handy if the years ever changed - you could just change them in the table without having to change the expression.