DateDiff using the whole date

  • Thread starter Thread starter AngiW
  • Start date Start date
A

AngiW

I need to find the difference in years between two dates, but I need to use the
whole date and not just part of it. IE: ContractDate and Today....how many
years has the contract been active? TIA!
 
Stan,
Actually I found two....don't think one works better than the other but I'm not
sure. I used this one:

DateDiff("yyyy",[ContractDate],Date())+Int(Format(Date(),"mmdd")<Format([C
ontractDate],"mmdd"))

In the Queries newsgroup there's one titled Calculate Age....that one worked
too, but I can't find it now. HTH

Ang
 
Back
Top