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

Month to Expiration Field to calculate expiration date

I have picklist called "Months to Expiration" that lists 1 Month, 2 Months, so on and so on to 12 months.  I want to calculate an expiration date field from another date field (Activation Date).


Has anyone done this?  I can't just use +30, +60 etc because months aren't truly structured that way.


Any help is appreciated.



piyush parmarpiyush parmar

suppoer u have select 1 month,


if(ISPICKVAL(Months to Expiration,'1'),expiration date=Activation Date + 30,false)


This is simple way to set value.

You can also write formula using case !!