Flow with Dates Filter Query

(0) Share

Report

Posted on by RJF61

1,265

Hello,

I have a Flow where I am using a "Get items' to collect records based on dates. To verify steps, I have created "Compose" steps for identifying a StartDate and EndDate. I am then using these in the Filter Query of the Get items.

What I don't understand is why the Filter Query does NOT pull records for the "equal" portion of "ge" and "le"? It appears the function is more of a between dates. When I run the Flow, I receive records with Created dates of 8/1/2022 through 8/4/2022.

Can someone assist me?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

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

Like (0)

Report

Filter query requires the dates to be in the format yyyy-MM-dd . Try the following example:

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

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

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
RJF61 1,265 on at

Like (0)

Report

@ekarim2020 Thanks for the response.
As you suggested I updated the date formats but am still not receiving data that was entered on 2022-07-31 or 2022-08-05.

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report

@ekarim2020 Is it possible there is an issue using the "Created" field?

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

Hi @RJF61 ,

Please post a screenshot of the runtime output of Get Items action. This will show us the actual values for the filter query, for example:

You can use a Select action to select just the the IDs and Created dates for easy reference:

Looking at the runtime outputs of the Select action shows that the Get Items filter query is working as expected:

The results seem to be in the range (Created date greater or equal to '2022-07-31') and (Created date less than or equal to '2022-08-05'):

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
RJF61 1,265 on at

Like (0)

Report

Following are screen shots.

I did review the Select 2 information and the Query Filter did not return 2022-08-05 dates.

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report

As a side note, I did create another date field "CreatedDD" and copied the Created dates to the new field. Running the Flow from the CreatedDD field, I receive the correct data.

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

Just an important note about the filter query.

To include all records created on the 2022-08-05 (EndDate) and I mean anything created between 2022-08-05 Hour:00 Min:00 seconds:00 and 2022-08-05 23:59:59, you will need to adjust the EndDate by one day, and change the operator to less than (lt):

~~StartDate ge 2022-07-31 and EndDate le 2022-08-05~~

StartDate ge 2022-07-31 and EndDate lt 2022-08-06

Updated EndDate expression:

Updated Filter Query:

Get Items runtime:

Select action updated to show time and includes all records created on 2022-08-05:

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
RJF61 1,265 on at

Like (0)

Report

@ekarim2020
Thanks for the help. I’ll make the updates this evening. Does this mean I am misunderstanding the equals portion of “ge” and “le”? Initially I wanted to run a report every Friday for all records from Sunday through the Friday report day (run report on Friday 8/5 for 7/31 through 8/5).

Was this reply helpful? Yes No