+ Start a Discussion
JeffreyStevensJeffreyStevens 

Flow formula - date functions - addMonth()?

Are there additional functions available in the Flow Formula editor - like in a normal field formula editor?  If so, where are they described (they are not in the Flow Designer Guide)

Thanks,

Jeff
Silkcutz01Silkcutz01
I know you can add days in formula, so date + 9 will give you 9 days ahead. 
I wonder if you can get month number (e.g. November = 11) and do IF formula to then add 30, 31 or 28 based on the month number. Leap year may be a pain though. 
Kristine CuringtonKristine Curington
You can add days, months, or years to a date.  
Example: 3 months from today
DATE(
YEAR(TODAY()),
MONTH(TODAY())  + 3,
DAY(TODAY())
)
Ekaterina GetaEkaterina Geta
Hello Jeffrey,

There now is!

You can also use a new ADDMONTHS function.

For more details refer here - http://getawayposts.com/add-months-date-salesforce-formula-addmonths-function