calculating a date field in reports

[230173]

Hi,

I've made a report from a table but now i want to ad a field that calculates a date. It takes a value from a table with a date in and adds 5 years to that date.
So I've made a textbox and this is the text:
=DateAdd("yyyy",5,[FirstDate])

But i get an error sayoing that my synta is wrong.
What am i doing wrong?

 

[JeremyNYC]

Is it possible there are null values in the FirstDate field (kinda sad, I guess!)? If so, that might be what causes the problem, because your syntax looks fine.

Also, is that field a date field?

Hmm. Actually, I just checked all these possibilities and it still seems to work. Now I'm confused.

Are you sure that's the error you're getting and that's where you're getting it?

Weird.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.