Under Consideration

Ability to have date type in the Case statement - Rules engine

Userlevel 4
  • Gainsight Employee: Shoshin
  • 4 replies



The out data type here is limited to number, string and boolean. But we have encountered multiple usecases where the final out put fields needs to a date based on set of conditions/criteria.

Is this something in road map?

This ability to have date type in the case statements is not a possibility in Data Designer also.

If we can have the ability then it would be super helpful

2 replies

Userlevel 7

Hi @shivani 

This is a good idea. Can you also add some usecases that you might want to accomplish with case and dates?

Company has sales orders and change orders to the original sales order. Sales order always has a service start and service end dates. Change order should have the same but not always depending on the reason for the change order.

If I’m pulling products out of the change order and need to have the service start and end date then the logic would be:

If change order service start date is null
then sales order service start date
else change order service start date

Same for service end date