4 Replies Latest reply: Oct 3, 2017 6:38 AM by naveen kumar RSS

    how to get min date when a fiscal year or fiscal year pluse quarter is selected

    naveen kumar

      Capture.PNG

      Hello All,

                        From the above sample data for a particular material ,when either a fiscal year(2017) or fiscal year pulse quarter one(Q1) is selected i need to bring PRICE_MAT =1.75(VALIDFROM=4/2/2016)  and

      If Fiscal year and Quarter Three(Q3) is selected then i need to bring PRICE_MAT=1.8 which is having max VALIDTO(12/31/9999) for that particular material ...


      How to write a expression to achieve the above requirement ,any suggestions please


      Thanks