DATEADD

The DATEADD function adds or subtracts a specified interval from a date value. By default, the function adds the specified number of days when the interval is not provided.

Note

The input dates should be in MM/DD/YYYY format. References are also accepted as arguments.

Syntax

DATEADD(date, count, [interval])

Arguments

• date: The input date.

• count: The number of intervals to add or subtract. Positive values add intervals, and negative values subtract intervals.

• interval (optional): The interval type to apply. Supported values include "day", "month", and "year". If not specified, the function uses "day" by default.

Return value

Returns the calculated date.

Examples

DATEADD([Open Date], 5)

Adds 5 days to the Open Date value.

DATEADD([Open Date], 1, "month")

Adds 1 month to the Open Date value.