Skip to main content
pthallapalli
Gainsight Employee ⭐️
pthallapalli
Gainsight Employee ⭐️
December 10, 2019

Customized Date and Time functions

It would be great if we introduce the time and day functions in rules and reports.

These type of functions will help in analyzing the day wise data.
 

    2 replies

    phani_kumar
    phani_kumar
    Gainsight Employee ⭐️⭐️
    June 22, 2020

    +1.

    Yes, if we can able to get the Year, Month, Date as separate fields from Date Datatype using Date functions that help a lot in analyzing the data in day-wise or month-wise or Year-wise.

     

    Thanks.

    Translate
      rakesh
      Gainsight Employee ⭐️
      rakesh
      Lets put your data to work!
      June 23, 2020

      Hi All,

      We already have first day of month, qtr, etc. formulae in both Rules and Reporting. The reason why we have this is because we retain the data type which can be then used for downstream processes. 

      Is there any limitation with the same thats stopping you from getting your analysis? Can you share some examples?

       

      Another follow up question - We can summarize the data by month/day/year when we analyze the data in report builder or when we prepare the data in Rules Engine. I also want to know if that can solve the use cases mentioned above. 

      Translate
        Terms & ConditionsAccessibility statement