Skip to main content
heather_hansen
heather_hansen
VIP ⭐️⭐️⭐️⭐️⭐️
May 14, 2019

Formula Fields in Report Builder and Data Management

  • May 14, 2019
  • 3 replies
  • 84 views
Would be great if you had more options for Date Diff. For example, I wanted to set up a column to show Days Until Renewal, but I can't choose TODAY as the one of the options. I also can't just enter today's date.

      3 replies

      kate_green
      kate_green
      Helper ⭐️⭐️
      May 14, 2019
      Heather - in the second field for Date Diff you can choose Rule Date. So you could choose Date Diff(Renewal Date, Rule Date, Days) and then you'll have the difference in days to the renewal date. Does that help?

      heather_hansen
      heather_hansenAuthor
      VIP ⭐️⭐️⭐️⭐️⭐️
      May 14, 2019
      I didn't see that option in the Report Builder formulas or the Data Management formulas. Just in the Rules Engine.

      kate_green
      kate_green
      Helper ⭐️⭐️
      May 14, 2019
      Oh sorry I misread your question!

      I have added a Today field to my MDA tables where I'd like to calculate the difference between a specific Date and Today. I just use a rule to load today's date to the Today field each day. Not great but it works!

      Terms & ConditionsAccessibility statement