cp Posted July 1, 2002 Share Posted July 1, 2002 Hi there, I need a way to calculate the age of a record. I have a calculation field called "date_created" and another called "age" "age" is equal to Today - date_created This works fine when the record is first created (age =0, like you would expect) but age does not update as the days pass. This database needs to be running constantly so I can't close it and open it every morning. Quote Link to comment Share on other sites More sharing options...
StevenB Posted July 1, 2002 Share Posted July 1, 2002 Set the Age field so that it does not store the results. Click on Storage Options and check the box. That will update it everytime you look at the record. HTH Quote Link to comment Share on other sites More sharing options...
David Head Posted July 2, 2002 Share Posted July 2, 2002 The Today function will only reset when the file is closed and re-opened. Therefore, you should use the Status(CurrentDate) function in your calculation and, as Steven says, make sure the result is unstored. Age (num) = Status(CurrentDate) - date_created That will work. Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.