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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Datediff 2
End of Month: Parameter Query? 3
Date difference to show in years and months 2
Can't query DateDiff 3
Columns using month and year 1
Iif Query 5
DateDiff returning incorrect years 11
Query by Month and Year (Repost) 2

Back
Top