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
