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.
aws148Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Will LovingPresident, Dedication Technologies, Inc.Commented:
Under the "Storage"  options for the field make sure indexing is set to None. This should force the field to recalculate continually.
0
aws148Author Commented:
Thanks.  

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.
0
Will LovingPresident, Dedication Technologies, Inc.Commented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
aws148Author Commented:
OK, thanks very much for your help.  Much appreciated.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.