Flow with Dates Filter Query

[RJF61]

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?

[ekarim2020]

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.

[RJF61]

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

[RJF61]

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

[ekarim2020]

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.

[RJF61]

Following are screen shots.

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

[RJF61]

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.

[ekarim2020 · Accepted solution]

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.

[RJF61]

@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).