G
Guest
I am using Datediff function to calculates how many months are between dates.
But I have found that the function only counts the months and not the actual
dates.
e.g. 1/24/06 and 2/4/06 will yield 1(one) even though it is really 0(aero).
I use Int(Datediff("d", xdate, ydate) / 30). However, this isn't really
that accurate when Feb and the months with 31 days are considered. Any other
suggestions would be appreciated.
Mike
But I have found that the function only counts the months and not the actual
dates.
e.g. 1/24/06 and 2/4/06 will yield 1(one) even though it is really 0(aero).
I use Int(Datediff("d", xdate, ydate) / 30). However, this isn't really
that accurate when Feb and the months with 31 days are considered. Any other
suggestions would be appreciated.
Mike