function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Can I add a number of months to a date field in a field update formula

Something like...


date_field + 3 months

Jake GmerekJake Gmerek

You you want to get back the same date in that month


so Jan 4 would become march 4?


if (month(today()) < 10, date(year(today()),month(today()) +3,day(today())), date(year(today())+1,month(today()) -9,day(today())))  should give you today plus three months.  


Yes, so if the date in QCCP_Last_Call__c field is 3/1/2011, then i want it to update to 6/1/2011

Jake GmerekJake Gmerek

Perfect, just take my formula from above and whereever I have today() change it to QCCP_Last_Call__c.  Should do what you want it to do.


I didn't get any syntax errors, so that's good.  I'll have to create my workflow rule and test it.  I'll let you know.  I'll probably have more questions when i get to that.  Thanks for the help.


So you have an idea what i'm doing...


I want this field update to run, when a user moves a Task with a given name, given created date and status moves to Complete.