function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
JFroJFro 

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.  
JFroJFro

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.
JFroJFro

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.