DateDiff

[jacqueline]

I am calculating the difference between dates, I first
calculate
days : datediff ("d", date1, date2) It gives me 48 days.
months: datediff("m", date1, date2) It gives me 2 months.
Should that say 1 month instead of two?
86 days gives me 3 months or 21 days gives me 1 month


jackie
..

 

[Jim/Chris]

Why not use days and divide by 30 for # of months

Jim

 

[Duane Hookom]

Most DateDiff() usage reports the number of "boundaries" that are crossed
betwee two dates.