Calculating the age of a record.
Something which i thought would be simple is beginning to make my head spin. !
All i need to do is for a field to constantly calculate the age of a record (in days).. which i thought would be easy but alas!
I have 2 fields: Date and Age of Record.
Date is 'auto enter' Creation Date
Age of Record is a calculation Get (CurrentDate) - Date
What i really need is for the Age of Record to constantly update. Can anyone help me with how i do this please?