Skip to main content
trevor_shand
trevor_shand
Helper ⭐️
June 13, 2024
Solved

Days Since Last Activity Date

  • June 13, 2024
  • 2 replies
  • 95 views

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.

    Best answer by spencer_engel

    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.

     

     

    2 replies

    spencer_engel
    spencer_engelAnswer
    Expert ⭐️
    June 13, 2024

    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.

     

     

      trevor_shand
      trevor_shandAuthor
      Helper ⭐️
      June 13, 2024

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

        Terms & ConditionsAccessibility statement