<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#999999" text="#000000">
Hi,<br>
<br>
When trying to get the number of months between the following dates:<br>
01-06-2009 and 01-08-2008<br>
<br>
MonthsBetween returns: 9 months.<br>
<br>
That is clearly wrong (fundamentally counting with my fingers yields 10
months).<br>
Looking at the function in dateutils.inc, I copied the function
implementation to do a test.<br>
Now, if I strip away Trunc() from the function, the result is:
9.98767967.<br>
Trunc() simply strips away the decimals behind, which returns: 9.<br>
<br>
I'm wondering if Round() should be used instead of Trunc().<br>
<br>
Regards,<br>
Funky Beast.<br>
</body>
</html>