Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Age of Record


Recommended Posts

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.

Link to comment
Share on other sites

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.



Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use