Adds a duration to a date.

Syntax:

date #DATEPLUS duration

Examples:

1/1/1995 #DATEPLUS 1y2m5d equals 3/6/1996

5/8/1970 #DATEPLUS 65y equals 5/8/2035

This operator is useful for determining a normal retirement date. For example, if the field DOB contains the value 11/15/1936, then DOB #DATEPLUS 65y returns 11/15/2001.

Related Operators:

#DATEMINUS