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
Am I correct or is there a simpler way?
Michael
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
