Is there a way to create a field on a data table, that will calculate the difference between today and a date in a field? Our use case is, we have an activity done by a CSM and we capture that date. What I would like is a field that then shows, “It’s been X days since that activity was done. This can be done with a rule, but I’d like not to have to use a rule. I was sure there was a way to create a formula field on a data object but for the life of me I can’t remember how...or I am crazy and there isn’t a way to do this without a rule. Any help is appreciated. Thank you.
Days Since Last Activity Date
It is a little convoluted to find, but this is possible. You’ll go to Data Management and add a “Number” field. You then click “show advanced options” and click “Create Formula.” Once there, you’ll want to click “Function” and choose “Date Diff.” Then you can build your formula - in my example I’m showing the difference between Today and Renewal Date with “DAYS” as my interval.
![](https://uploads-us-west-2.insided.com/gainsight-us/attachment/209eeb30-0cc1-4e86-9aa6-5b173808c558.png)
![](https://uploads-us-west-2.insided.com/gainsight-us/attachment/d6d45937-7eac-49ed-b546-c1b1c6cc7980.png)
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.