how to calculate age using a fixed month & day with "now" year

[Guest]

I need to calculate age on Dec 2 of the current year & I don't want to have
to change the year by hand ... how can I use a "hard" month & day with a
"current" year? thanks for your help

 

[Rick Brandt]

I need to calculate age on Dec 2 of the current year & I don't want
to have to change the year by hand ... how can I use a "hard" month &
day with a "current" year? thanks for your help

DateSerial(Year(Date()), 12, 2)

 

[Van T. Dinh]

See The Access Web

http://www.mvps.org/access/datetime/date0001.htm

Check the alternatives in the article.