Has Anyone implemented a rule to subtract the month from the given date? Which handles last day of the month leap year as well
Discussion posts and replies are publicly visible
Hi ajinkyab277, there is a Shared Component which contains a function named as lastdateofmonth() which accepts a Date as input, and returns the last day of that particular month including Leap year.
e.g: lastdateofmonth(todate("02/12/2016")) => Which Returns: 2/29/2016
lastdateofmonth(today()) => Returns: 7/31/2017
And for subtraction, you can simply go for edate() function as suggested above.
You can use edate() funtion for manupulate the DATE
There's built-in functionality that accomplishes this: eomonth(today(),0) returns 2017-07-31. No plugin needed.
eomonth(today(),0)