How to use SUBMONTHS function in vFlow2.0?

vFlow-2.0
1

Why do we use SUBMONTHS function in vFlow2.0?

1 Like
2

The SUBMONTHS function subtracts a given number of months from a specified date. For example, if the input date is 05/10/24 and you subtract 3 months , the function processes the subtraction and returns 05/07/24.

Syntax- SUBMONTHS(date, dateFormat, NoOfMonths, outPutDateFormat)

Example- SUBMONTHS(“2024-10-05”, “yyyy-MM-dd”,“3”,“dd/MM/yyyy”)

2 Likes