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.
Formula Fields in Report Builder and Data Management
+14
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?
+14I didn't see that option in the Report Builder formulas or the Data Management formulas. Just in the Rules Engine.
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!
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!
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.