query using datediff to calculate time in years and months

  • Thread starter Thread starter Dow_Jones
  • Start date Start date
D

Dow_Jones

I wish to query my data and retrieve the following information.

Start Date = 1/1/2000
Today's date = 3/23/2009

The results of the query should reflect "9 years 3 months". Is this
possible? If so, what is the formula / expression to gain this info?

Thanks to all.
 
Format(Date() - #1/1/2000#, "yy m") & " Years/Months"

The above will be a problem if the start date is over 100 years before the
current date.
 
Back
Top