DateDiff using the whole date

[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!

 

[Angi]

Never mind...I figured it out.

 

[Stan]

Never mind...I figured it out.

So what was it?

Stan

 

[Angi]

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