Answered

OData Date Range

Like (0) Share

Report

Posted on 16 Mar 2022 17:22:53 by Cjohnson20

I am trying to make an Odata filter that will only take data entered within the last week from my source so instead of a specific date range it is a rolling range from 'Today'. Is that possible?

All responses (2)

Answers (1)

Cjohnson20 31 on 17 Mar 2022 at 12:41:38

Like (0)

Report

Re: OData Date Range

Hey Ellis. This worked in my flow. Thanks for the help.
Verified answer

Ellis Karim 10,994 Super User 2025 Season 1 on 16 Mar 2022 at 22:11:14

Like (1)

Report
Re: OData Date Range

You can use the utcNow() to get the current date and addDays() function to add or substract days from the current time.

addDays(utcNow('yyyy-MM-dd'), -7)

For example, in the following filter query I am searching for items that were created between today (2022-03-16) and 2022-03-09:

Hope this helps.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.