B
Bill Cunningham
I need a formula to calculate [number of years] ago today.
Please help
Please help
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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".
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".
D
Dirk Goldgar
Bill Cunningham said:I need a formula to calculate [number of years] ago today.
For 21 years ago:
=DateAdd("yyyy", -21, Date())
J
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())
B
Bill Cunningham
Wow - fast easy and accurate.
Dirk Goldgar said:Bill Cunningham said: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)