Ways to Count Days Since Record Creation in Automation Systems

Jake G. · 2025-11-03T17:45:38.657Z

Hey guys, curious how i can implement this. I want to count days since a record was created, but when i use a formula it doesn't update automatically. What other methods has anyone found to make that work?

Ways to Count Days Since Record Creation in Automation Systems | Clay

7 comments

· Sorted by Oldest

Clay Support
APP
·
·
To keep a column updated with the count of days since a record was created, you can:
Use a formula referencing the "Created At" column and JavaScript date functions (like moment()), which is the standard approach. However, formulas only recalculate when a row is updated, so the value won't auto-refresh daily [1].
For more dynamic updates, set up an automation using webhooks and enable Auto-Update. This allows your table to process new or refreshed data automatically, ensuring your "days since created" value stays current as new data comes in .
Alternatively, use an AI formula with a prompt like "How long ago was /start date from today" to calculate the duration as a decimal, which can be helpful for tenure tracking or similar use cases .
If you need the value to update daily without manual intervention, automating data refreshes via webhooks and Auto-Update is the most reliable method.
Clay Support
APP
·
·
Did that answer your question?
Jake G.
·
·
Not really. I have a column in the row that updates daily, would that trigger a recalculation of the formula?
Clay Support
APP
·
·
I understand this can be frustrating. I’m routing you to one of our human agents who can provide more detailed help.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Amit K.
·
·
Hey Jake- could you send me your table link and I could take a closer look?
Clay Support
APP
·
·
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!