#DATEMINUS
Subtracts a duration from a date.
Syntax:
date #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: