Sign Up ›

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

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.

 

Thanks,

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 !!