2 Replies Latest reply: Oct 20, 2017 8:07 AM by Sunny Talwar RSS

    Simple Set Expression Required

    zahid Rahim

      Dear Experts,

       

      I have below mentioned data where i want to extract one value based on a filter date. 

       

      Value     Trdate

      10               01-JAN-2017

      5                 01-APR-2017

      4                  01-MAY-2017

      9                  01-JUN-2017

      3                  01-JUL-2017

      2                  01-AUG-2017

      7                  01-SEP-2017

       

      If the filter date is 30-JUN-2017 Then it should give only one value 9 on 01-JUN-2017

      If the filter date is 31-MAR-2017 THEN it should return 10 on 01-JAN-2017

       

      I mean the previous date value from the filter date

       

      Regards,

       

      Zahid Rahim