Updating a Date difference Calculation field

I'm working in Filemaker Pro v12.

I have a date field "RecordDate" which records the date that the record was opened.

I want to have a field that will return how many days ago from "today" (as today changes its date) the record was opened.

I have tried using a Calculation field with the formula = Get(CurrentDate) - RecordDate but this does not change its output each date, as "today" changes.  

I don't fully understand the Get(CurrentDate) function but I think it's just returning the date when the field is first calculated, and I don't think it returns a new date for each day thereafter.

Be grateful for guidance on creating a calculation field for the days since RecordDate that will update by 1 each time midnight passes.
Who is Participating?
Will LovingPresidentCommented:
That was going to be my other suggestion to you, I forgot to mention it in the first post. Turning off indexing and unchecking the "Do not evaluate..." checkbox are generally what I do when I need something to always calculate.
Will LovingPresidentCommented:
Under the "Storage"  options for the field make sure indexing is set to None. This should force the field to recalculate continually.
aws148Author Commented:

The bullet point for Indexing was already set to None, but "automatically create Indexes as needed" was ticked.  

I unticked that box, but there was no change to the result.

Since it was implied in your answer that Get(CurrentDate) ought to work to change its output each day, I tried other small variations to the calculation field.

unticking "Do not evaluate if all referenced fields are empty" seems to have cracked it.  I'm now getting the correct output.  Don't understand why, because the only referenced field was definitely not empty.
aws148Author Commented:
OK, thanks very much for your help.  Much appreciated.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.