1 of 1 people found this helpful
Can you change in Excel - that is easiest - it's under Options.
Otherwise you can just do a dateadd('year',4,[your date])
I did try changing the date format so that it's not using the 1904 system but that gave me the same error. For the time being I guess a dateadd would solve it.
Hmm, that's fixed it in the past. I would definitely use dateadd then.