4

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?

9

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.

| improve this answer | |
  • Thanks! I thought so but wasn't sure. – anwarabq Oct 19 '15 at 5:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.