Answered

OData Date Range

(0) Share

Report

Posted on 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?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ellis Karim 11,695 Super User 2025 Season 2 on at

Like (1)

Report
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.

Was this reply helpful? Yes No
Cjohnson20 31 on at

Like (0)

Report

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

Was this reply helpful? Yes No