Filter by Fiscal Quarter in Rules Engine
FirstDayOfCurrentWeek(), FirstDayOfCurrentMonth(), FirstDayOfCurrentQuarter(), LastDayOfCurrentWeek(), LastDayOfCurrentMonth(), LastDayOfCurrentQuarter() are now available in the transformation task of Bionic Rules. These functions can take Rule date or any date as input.
Apart from these, there are few other date functions that were introduced in fall release. Let me know if this helps.
We need the ability to group dates by fiscal quarter in rules engine. Is there currently any way to transform a date into a fiscal quarter/year?
We are considering this as a part of overall enhancements to the rules engine in the medium term horizon.
Hey Team… I had a chat with a customer on this today. Is there anything we can share at this time?
Frankly I’m really surprised to see Gainsight continue to add new features (i.e. CSQL) when fundamental challenges like this (and plenty of others) still exist.
Would really like to use CQ or FQ in criteria under Rules engine when loading to Gainsight object as well…
For example, if ‘subscription deactivated at date’ equals Current Quarter…

Just adding my +1 to this!
Reply
Login to the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.