#DATEMINUS
Subtracts a duration from an end date, returning the start date.
Syntax:
enddate #DATEMINUS duration
Examples:
7/1/1995 #DATEMINUS 1y2m1d equals 4/30/1994
1/1/2008 #DATEMINUS 30y equals 1/1/1978
This operator is useful for determining an approximate date of hire based on service. For example, if the field SVC95 contains the value 22.5, then 1/1/1995 #DATEMINUS (1y * SVC95) returns 7/1/1972.
Related Operators:
If instead you want to measure the number of years between two dates, use #YEARDIF.
If instead you want to measure the number of days between two dates, use - (minus), as in enddate - startdate.