ADD_DATE Function


Function Type

Predefined function

Syntax

ADD_DATE( <dateValue>, <days> )

Description

Adds a specified number of days to an existing date.

Argument

Description

<dateValue>

Any date type or string in "MM/dd/yyyy" format.

<days>

Integer representing the number of days to add to <dateValue>.

Important

The MM in the date format is in uppercase because the lowercase mm refers to minutes.

Returns

Date

Example

The value of the source field, indatefield, in Table1 is "01/01/2003", and the number of days to be added to this date value is 35.

ADD_DATE(Source.Table1.indatefield,35)

This example returns "02/04/2003".



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*