Return 12 months instead of 365 days

Question

I have a field update as part of a WFR that returns a date 366 days in the future. I need this to be 12 months but I can't seem to figure it out.

This is the current field update formula:

Next_Renewal_Date__c +366

Note: This is currently part of a WFR that someone else made up that I'm attempting to adjust. It works as intended for days but 12 months is more accurate for what I need.

Thomas Lange Jr. · Accepted Answer

This should work for you:     ADDMONTHS(Next_Renewal_Date__c, 12)

Return 12 months instead of 365 days

Data Management

Risorse di formazione correlate

Ulteriore assistenza