Solved

Days Since Last Activity Date

  • 13 June 2024
  • 2 replies
  • 13 views

Userlevel 2
Badge +2

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.

icon

Best answer by spencer_engel 13 June 2024, 17:04

View original

2 replies

Userlevel 7
Badge +3

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.

 

 

Userlevel 2
Badge +2

@spencer_engel  This is exactly what I needed. Thank you. 

Reply