Adds a duration to a start date, returning an end date.

Syntax:

startdate #DATEPLUS duration

Examples:

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

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

8/30/2020 #DATEPLUS 6m equals 3/2/2021

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