Sharepoint get items filter

[elaaadani]

Hello, good afternoon.
I have a query
I am dealing with error when viewing 5000 data with get items connector.
I would like to know how I can use the filters for a column that has only one date in simple date format.
I have tried with putting the name of the column +eq+ the data I need, but I can't get it to do it.

'Modified' eq '28/04/2017'

Please help me !

[henkenTech]

Try formatting the date as yyyy-MM-dd instead and no ‘ around Modified. That should do it 👍🏻

Modified eq '2017-04-28'

[elaaadani]

Thanks @henkenTech , I did it this way but apparently, it does not take the column, since I get an empty query.

"value":[]}}

I don't call sharepoint before as to get the column, only in get elements, as I am testing to handle this threshold. only in get items, as I am testing to handle this threshold.

[henkenTech · Accepted solution]

It just came to me:

Modified is a timestamp with a time value, so if you are looking for a particular date, you’ll have to sandwich the timestamp between two values using an “and” operator. "2021-04-28" would literally be 00:00 on that date and your Modified column timestamp is not equal to that.

e.g.: for e.g. 2021-04-19 it would be: 

Modified ge '2021-04-19' and Modified lt '2021-04-20'

that wound filter any value between 00:00 on the 19th and 00:00 on the 20th.

Just tested this and works on my side 

[elaaadani]

Thank you for your kindness @henkenTech