All Ideas

Idea Details

Post an Idea
This idea has been delivered and can no longer be voted or commented on. If you’d like to add to this conversation, please post a new idea.
4,770  Points voting closed
Delivered in Winter 18
Idea is generally available.

Need the ability to add and subtract months and years in formula fields.

Custom Schema

Currently we can add days to a date however we can not add months in custom formula fields. The closest accuracy we could get would be to add 30 days per month to the date. Unfortunately "close enough" this is not acceptable in business when it comes to things like contract expiration dates. Years would be feasible yet cumbersome to add using the DATE and YEAR functions but I'm not able to come up with any ways to properly increase dates by months.

· Flag

  • Upvotes
  • Downvotes



from AppExchange


Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.