DateDiff - need years and months

[Bonnie A]

Hi everyone! Using A02 on XP.

I have rates to calculate frequently and have to calculate how many years
and months between two dates (day of the month isn't needed but I don't mind
using it). I made a form with [StartDate] and [EndDate] and a Result field
with this in the Control Source:

=DateDiff("d",[StartDate],[EndDate])

I can calc the number of days but need months and years (for example; 3 yrs,
5 mos and 18 days).

I've tried to play with it but it just errors. What is the proper form to
use for 'show it to me this way'?

Thank you in advance for any help or advice!

 

[Allen Browne]

Doug Steele et al created a more complete DateDiff:
http://www.accessmvp.com/djsteele/Diff2Dates.html

 

[Bonnie A]

Thank you VERY much Allen. I discovered all I needed was "ymd". I tried
"dmy" and got errors.

I appreciate the time you take to help others. I LOVE Access!
--
Bonnie W. Anderson
Cincinnati, OH

Doug Steele et al created a more complete DateDiff:
http://www.accessmvp.com/djsteele/Diff2Dates.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi everyone! Using A02 on XP.

I have rates to calculate frequently and have to calculate how many years
and months between two dates (day of the month isn't needed but I don't
mind
using it). I made a form with [StartDate] and [EndDate] and a Result
field
with this in the Control Source:

=DateDiff("d",[StartDate],[EndDate])

I can calc the number of days but need months and years (for example; 3
yrs,
5 mos and 18 days).

I've tried to play with it but it just errors. What is the proper form to
use for 'show it to me this way'?

Thank you in advance for any help or advice!

 

[Allen Browne]

Thank you ...

I appreciate the time you take to help others. I LOVE Access!

Oh dear: you're starting to sound like an Access addict.