Performs calculation on a Date variable.

Constructs a date out of an input date and 3 values to be added to that date: years, months, and days. The result is always a valid date.

Syntax:

AddDate(date,years,months,days)

Parameters:

date – A date.

years – The number of years to add to date. Can be zero.

months – The number of months to add to date. Can be zero.

days – The number of days to add to date. Can be zero.

Returns:

Date value

Example:

AddDate('01/01/1992'DATE,1,2,2) returns 03/03/1993

See also:

DVal

How Do I Increment a Date Value?

The Online and Rich Client Samples projects (program DT04 and RDT04)