Create a calculation field in your database and set the calculation to be:
Get(CurrentDate) - StoredDate
where 'StoredDate' is what ever your field is that has the enrollement date in
You will need to make sure the calculation is unstored (tick the "Do not store calulation results - recalculate when needed" under Storage Options on the Specify Calculation dialogue
1 of 1 people found this helpful
You need two fields, one to store the date you started serving them, and another calculated field with a calculation of:
get(currentdate) - yourTable::dateServed
Where yourTable is your table name, and dateServed is the date you started serving them.
Make sure to set the calculation to unstored, so that it always displays an updated date.
Thank you! this was it!
I did not have the Storage Options properly set.