DateDiff function?

[kbreiss]

I'm trying to add a txtfield that the control source is 65 years prior the current date.

So the control source should come up with "1940". I've tried the datediff function, but not having any luck...any suggestions?

Thanks.
________
Mexicocity Hotel

 

[kbreiss]

NeverMind

I've got it....for any of you that are curious...

=Format(DateAdd("yyyy",-65,Now()),"yyyy")
________
Herbalaire Review

 

[Bat17]

Well done here is another way of doing it that is perhaps slightly clearer
=Year(DATE()) - 65

Peter