+ Start a Discussion

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)


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
MONTH(TODAY())  + 3,
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
Jay KadirveluJay Kadirvelu
Not applcable to Flow