Description
Returns a datetime value that is the result of adding a specified number of days to a datetime expression.Syntax
DateAddDays(datetime_expression, days)
Arguments
datetime_expression - string expression in ISO 8601 format. days - integer expression representing the number of days to add. Use a negative value to subtract days.Examples
DateAddDays('2009-01-07T01:07:01.000Z', 10) returns ‘2009-01-17T01:07:01.000Z’
DateAddDays('2009-01-07T01:07:01.000Z', -5) returns ‘2009-01-02T01:07:01.000Z’