21 years ago today

[Bill Cunningham]

I need a formula to calculate [number of years] ago today.

Please help

 

[Dorian]

You need to be more specific!
To compare dates, you need two of them. You only mentioned one (today).
Also, you need to specify how you want it to work i.e. whole years or
partial years?
Take a look in Access help at the DateDiff() function.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Dirk Goldgar]

I need a formula to calculate [number of years] ago today.

For 21 years ago:

=DateAdd("yyyy", -21, Date())

 

[John W. Vinson]

I need a formula to calculate [number of years] ago today.

Please help

DateAdd("yyyy", -21, Date())

or

DateAdd("yyyy", - [Number of years], Date())

 

[Bill Cunningham]

Wow - fast easy and accurate.

I need a formula to calculate [number of years] ago today.

For 21 years ago:

=DateAdd("yyyy", -21, Date())

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)