+13Hey all,
Another area that lacks consistency or parity. Why can’t I add months or years to a date?
Can we please make this area of formula field consistent and allow us to add months and years to a date? Like we can in other areas.
In my use case, I have a license term in months, and I want to add months to the effective start date since effective end date is mostly missing.
+9Heavy +1!!
I’m also struggling a lot with the missing capabilities regarding date/ datetime fields.
I’m piggybacking on Alizee’s idea but I have several in that same topic 😅:
·First/Last Day Of Current Year
Use case: if I need to aggregate all opportunities of the same customer year by year, transforming the close date to the First Day of that and then grouping by GSID would do the trick.
·Capability to compare dates in a case clause with date data type as output
For example, if dateA < dateB, dateA, else, dateB
·Run datetime
This could be useful to show when a report from a dataspace was last updated, the same way a last modified date of a Company Record is shown in the local time zone of the end user.
+13
+2Ohh… Done.
Pl let me know if you spot this dodgy behaviour again.
+13If 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
