The Official Salesforce Blog

The Official Salesforce Blog

Is it possible for custom formulas to get out-of-date?

Jamie Grenney Jun 10, 2005

No. Custom formulas are recalculated with each request, so they are guaranteed to always be up-to-date, whether viewed on tabs, list views, reports, or through the sforce API.

 

3 Comments

Jamie

I would like to create a custom formula to calculate the # of days until an opportunity closes, any ideas?

Scott

Hi Jamie,

You can create a custom formula to calculate the # of days until an opportunity closes. In fact it's one of the examples given in a document on this website called "100 Ways to Use Formula Fields". Here's a link to the document:

http://www.crmsuccess.com/browse/content_detail.jsp?id=00630000002Hw5FAAS

Also, here is the example formula you're looking for from that document:

Days Left to Close:
Returns the number of days left to close

{!CloseDate} - TODAY()

Jamie

Thank you Scott, I appreciate your help!

Post a comment