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?

1 Answer 1


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.

  • Thanks! I thought so but wasn't sure.
    – anwarabq
    Commented Oct 19, 2015 at 5:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .