[SalesForce] Is a TODAY() value in a formula field updated every day

I want to use TODAY() in a formula field to calculate a person’s age based on the value in their date of birth field. Then I need to pull this field into a report. Will the TODAY() value be updated every day? Is there any other way I can calculate age in a report?

Best Answer

All formula fields are calculated at run time. No value is stored on the record for a formula field.

This means that any time you view a record, either through the UI or a report, the formula is calculated at the time you run it.

In short, yes.

Related Solutions

[SalesForce] How to write formula based on pick-list value of the pick-list field

Something like this will work

IF(
     ISPICKVAL(Status__c, 'Draft'),
     NOW() - LastModifiedDate,
     CreatedDate - LastModifiedDate
)

For more info on Formulas and Operators check some of these out

https://help.salesforce.com/HTViewHelpDoc?id=customize_functions.htm&language=en_US

https://developer.salesforce.com/page/An_Introduction_to_Formulas

http://www.salesforce.com/us/developer/docs/usefulFormulaFields/

https://help.salesforce.com/HTViewHelpDoc?id=tips_on_building_formulas.htm&language=en_US

[SalesForce] Formula for writing a specific Day of Week date value

A quick Google revealed this:

CASE(
MOD(TODAY()  - DATE(1900, 1, 8), 7),
0, TODAY() + 7,
1, TODAY() + 6,
2, TODAY() + 5,
3, TODAY() + 4,
4, TODAY() + 3,
5, TODAY() + 2,
6, TODAY() + 1,
DATE(9999,01,01)
)

that I assume could be refactored a bit and changed for your case to:

CloseDate + CASE(
MOD(CloseDate  - DATE(1900, 1, 8), 7),
0, 7,
1, 6,
2, 5,
3, 4,
4, 3,
5, 2,
6, 1,
0
)

Adding 1 to a date moves it on a day.

Best Answer

Related Solutions

[SalesForce] How to write formula based on pick-list value of the pick-list field

[SalesForce] Formula for writing a specific Day of Week date value

Related Topic