This function will add a specified number of days to a date.

 

Syntax

 

ADDDAYS((x), y)

 

Parameters

 

x = a date. This is the date you wish to use to add days to, preferred format of YYYY,MM,DD such as 2019, 8, 22 for 22nd of August 2019. This can also be the name of a date attribute.

 

y = the number, either positive or negative, of days you wish to add to the date (x)

 

Type of Data Returned

 

A date will be returned.

 

Examples

 

ADDDAYS((2019, 8, 22), 8) will return 30th of August 2019.

 

ADDDAYS((2019, 8, 22), 15) will return 6th of September 2019.

 

ADDDAYS((2019, 8, 22), -15) will return 7th of August 2019.