Decimical - between two dates, YYYY

[Bill]

Hi,

I'm using a query and create two dates. I want two dates calculate by Year
into decicial - example

I don't want:
Years: DateDiff("yyyy",#01/01/1999#,#02/28/2003)). It will give me 4 Years.

I want:
Years: DateDiff("yyyy",#01/01/1999#,#02/28/2003)). I want to see the number
show as 3 years (decimical) 59 days .

YOur help would be much appreciates. I would need your help..!

 

[Douglas J. Steele]

Take a look at http://members.rogers.com/douglas.j.steele/Diff2Dates.html at
my site.

 

[Mingqing Cheng [MSFT]]

Hi Bill,

As MVP has provided a great method, I wanted to post a quick note to see if
you would like additional assistance or information regarding this
particular issue. We appreciate your patience and look forward to hearing
from you!

Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center