ADD_DAY( ) Adds a specified number of days to a date value. Syntax ADD_DAY(date, n) Arguments date The date or date expression that represents the start date. n The number of days to add to the start date. If you specify a negative number, the result is as if the number is subtracted from the start date. Returns The date value that results from adding the specified number of days to the start date. Example The following example adds 15 days to each date value in the InvoiceDate field: ADD_DAY([InvoiceDate], 15)
