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

8/30/2021 #DATEMINUS 6m equals 3/1/2020

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:

#DATEPLUS

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.