September 9, 2006
With your approach, Ralph, if you were to divide by 30.417 (1/12 of a
year) instead of 30, you’d get the exact number of months until you were
dealing with dates centuries apart, at least. For a whole number result
you could use the function, round.
Don Codling
WP 12.0.0.602
DP 2.6x
Windows XP home, SP2
512 MBytes RAM
Ralph Alvy wrote:
Don's solution seems much more accurate. But there's always the problem of
where in the month each date is. Consider these two dates:
Jan 28 2000
Mar 01 2000
Well, they're only 1 month and a few days apart. Do you want that to be
counted as 2 months or 1 month? I think on Don's scheme, the above
separation between dates will be 2 months, and on mine, 1 month. I think.
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
