6 Replies Latest reply on Jun 21, 2018 12:56 PM by Deepak Rai

    Displaying last four Quarters

    suvas.chandra

      Following formula works because both Parameter 2  and QE Date are Date fields:

       

      IF DATEDIFF('quarter',[QE Date],[Parameter 2]) >=0 AND

      DATEDIFF('quarter',[QE Date],[Parameter 2]) <5

      Then 'Last 4Q' END

       

      But now I have a different scenario. Both Parameter 2 and QE Date are string data type.

       

      How do I achieve the same thing ?