This content has been marked as final. Show 2 replies
I have below mentioned data where i want to extract one value based on a filter date.
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