Whats the correct ODATA for my Contains filter?

(0) Share

Report

Posted on by JuanArango

122

Hi,

I am having some trouble trying to get some rows from a list of sharepoint, currently im trying this filter in order to get all records that match the date:

contains(Fecha,'/01/')

I get this message

I also tried with substringof as ODATA v2 but same error pops up. Im using a get items action. These are my list's headers:

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Are you trying to filter by specific Month?

Was this reply helpful? Yes No
JuanArango 122 on at

Like (0)

Report
Copy link

Link copied!

hi @SudeepGhatakNZ, yes i am

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

I think contains wouldn't work because the data is stored in UTC format which wont match your '/01/' format.

Instead try this approach.

Solved: Filter Query to show last month - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
royg on at

Like (1)

Report
Copy link

Link copied!
As @SudeepGhatakNZ mentioned, If the field is of type Date, the way to filter for a specific month would be:
Fecha ge '2023-01-01' and Fecha le '2023-01-31'
If you store the dates in a text field in a "dd/MM/yyyy" format and not a date field, your OData filter would be:
substringof('/01/', Fecha)

Was this reply helpful? Yes No