Decimical - between two dates, YYYY

  • Thread starter Thread starter Bill
  • Start date Start date
B

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..!
 
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
 
Back
Top