On Saturday 09 September 2006 05:53, Michael Iannantuoni wrote: > I have two date fields formatted as DMYD99/9999 and want to find the > difference between them in Calendar Months. > > I've come up with the following, separated out for clarity into three > part by brackets: > > IF YEAR[date2] = YEAR[date1] THEN MONTH[date2] - MONTH[date1] ELSE (12 > - MONTH[date1]) + ((YEAR[date2] - YEAR[date1] -1) * 12) + (MONTH[date2]) > ENDIF
How accurate does this need to be? What if you just computed the number of 30-day periods between the two dates? Like this: (RecentDate - EarlierDate)/30 _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
