Simple Set Expression Required

[zahidrahim_ocp]

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

[Mark_Little]

Hi zahid,

I think you would have to take a look at interval match function in script, that why you can create a link in your data for the date gaps.

Have a look at the below

IntervalMatch

Mark

[sunny_talwar]

May be this

FirstSortedValue({<Trdate = {"$(='<=' & Date(Max(DateField), 'DD-MMM-YYYY'))"}>}Value, -Trdate)