Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Calculation based on Value List


Recommended Posts

I have a field that has 5 values selectable by radio buttons:

Term Lease, Mth to Mth, 3 Mths, 6 Mths, and 9 Mths.


I want to be able to calculate the lease term end date based on the value selected.


It Term Lease = End Date,

If Mth to Mth = Today + 30 or 31 days dependent on todays date.

If 3 Mths = Today + 90, 91, or 92 days dependent on todays date.


Etc. . . . .


I can't seem to get the formula to work based on this scenario.

Link to comment
Share on other sites

Ok, I figured out how to get the calculation by adding 30,60 etc. to a "CurrentDate" Field - however, how do I account for months with different days of the month?



Link to comment
Share on other sites

Try using


Date( Month(Status(CurrentDate)) + x, Day(Status(CurrentDate)), Year(Status(CurrentDate)) )


where x is the number of months to be added. Then you won't need to worry about the number of days in the month.


If you are using version 7, substitute Get in place of Status.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

Terms of Use