Not a problem, since the date fields only show months & years and
we are concerned with a monthly subscription to a magazine so October
& September should show as being only one month apart.
Ralph Alvy wrote:
On Sun October 29 06 02:37, Michael Iannantuoni wrote:
In September, I asked if there was a way to find the difference in
Calendar Months between two date fields formatted as DMYD99/9999.
Both Ralph & Don came up with solutions and I used those ideas to come
up with my own. It is only now, sometime later, that the obvious
occurred to me:
(year[P1F2] * 12 + mont [P1F2]) - (year[P1F1] * 12 + month[P1F1])
:-)
Michael
Hmmm...elegant. But what if, say, P1F2 is Oct 31 2006, and P1F1 is Sep 1 2006?
According to your formula, they're 1 month apart, even though they're 60 days
apart. Is that a problem for the application to real world concerns?
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
|
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
