Odata filter nor filtering

[BrianS]

I have added a filter to a Get Item step in a flow: InspectionDue le addDays(utcNow(),60,'yyyy-MM-dd')

but it does not filter out any data; the entire list is returned even though only about 4 items in the list have dates less than 60 from now.

How can I trouble- shoot this?

Here is part of the returned data:

Truck_Number	Due_Date
6196	2019-11-30
0045	2019-12-31
0047	2019-12-31
3518	2020-01-31
7906	2020-01-31
8540	2020-02-29
3553	2020-02-29
2474	2020-02-29
6359	2020-02-29
6928	2020-02-29
3250	2020-03-31

[tom_riha]

I'd say the filter works correctly, InspectionDue le addDays(utcNow(),60,'yyyy-MM-dd') will return all items where InspectionDue <= 2020-12-29, and all the dates you shared are less than December 2020. 

You should put there also bottom limit for today's date to get only items with InspectionDue between today and today+60.

InspectionDue le 'addDays(utcNow(),60,'yyyy-MM-dd')' and InspectionDue ge 'utcNow('yyyy-MM-dd')'

[BrianS]

I did not put in all the dates returned - you are correct all those would be returned. Sorry for the confusion. 

I have it working now