How to use ADDYEARS function in vFlow2.0?

vFlow-2.0
1

why do we use ADDYEARS function?

1 Like
2

The ADDYEARS function increases a given date by a specified number of years. For example, if you input 05/03/22 and want to add 2 years, the function will calculate the result and return 05/03/24

Syntax–> ADDYEARS(date, dateFormat, NoOfYears, outPutDateFormat)

Example–> ADDYEARS(“2022-03-05”, “yyyy-MM-dd”,“2”,“dd/MM/yyyy”)

1 Like