Date and Time Filter in ODATA URL

[Atinder]

Hello, 

I want to use date and time filter on the ODATA URL. I want to see all the entries from 2022-10-01 and I used this filter:  $filter=SystemCreatedAt%20ge%202022-10-01T00:00:00Z" but it not working. What filter do i need to use here? 

Thank you!

[Atinder]

Hi @v-binbinyu-msft ,

I tried but it is not working. 

[v-binbinyu-msft]

Hi @Atinder ,

Please try below:

• {startdate} - The date to start your trend report on. Format: YYYY-MM-DDZ. Example: 2019-04-01Z represents 2019-April-01. Don't enclose in quotes

For more details, you can read related document: Use OData queries to generate Power BI reports - Azure DevOps | Microsoft Learn

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.