Salesforce

AddDate (Magic xpi 4.13)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

AddDate (Magic xpi 4.13)

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 resulting date is always a valid date.

Syntax:

AddDate (Date date, Numeric year, Numeric month, Numeric day)

Parameter:

date: A date.
year
: The number of years to add to date. May be zero.
month
: The number of months to add to date. May be zero.
day
: The number of days to add to date. May 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?, Century

Reference
Attachment 
Attachment