How to use ADDMONTHS function in vFlow2.0?

vFlow-2.0
1

Why do we use ADDMONTHS function?

1 Like
2

The ADDMONTHS function is used to add a certain number of months to a given date. For instance, if the starting date is 05/03/24 and you add 5 months, the function calculates the result and returns 05/08/24.

Syntax–> ADDMONTHS(date, dateFormat, NoOfMonths, outPutDateFormat)

Exmaple–> ADDMONTHS(“2024-03-05”, “yyyy-MM-dd”,“5”,“dd/MM/yyyy”)

1 Like