How to use ADDDAYS function in vFlow2.0?

Why do we use ADDDAYS function?

1 Like

The ADDDAYS function is used to increase a given date by a certain number of days. For example, if the input date is 05/06/24, and you want to add 11 days, the function calculates the new date and returns 16/06/24.

Syntax–> ADDDAYS(date, dateFormat, NoOfDays, outPutDateFormat?)

Example–> ADDDAYS(“2024-06-05”, “yyyy-MM-dd”,“11”,“dd/MM/yyyy”)

1 Like