2 Replies Latest reply on Jul 12, 2018 3:53 AM by Tim Dines

    Date Calc

    suvas.chandra

      I have a Date field: QE Date
      I also have a parameter: Quarter End
      Quarter End was created from QE Date. Data type of Quarter End is string. I cannot change the data type for other reasons.

      Display format for Quarter End is: 2017 Q4, 2016 Q2 etc.

      Now, I want to show last five years data based on the parameter selection. I have Quarterly data. For yearly data, it should show data for Q4 only
      except for current selection.

       

      Use Case 1:

      If user choose 2016 Q2, data should display for: 2016 Q2, 2015 Q4, 2014 Q4, 2013 Q4, 2012 Q4

      Use Case 2:

      If user choose 2017 Q3, data should display for: 2017 Q3, 2016 Q4, 2015 Q4, 2014 Q4, 2013 Q4

      Use case 3:

      If user choose 2017 Q1, data should display for: 2017 Q1, 2016 Q4, 2015 Q4, 2014 Q4, 2013 Q4

       

      Any help ?

      Please remember, parameter is string format.