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.