Flow and Use of Dates

(0) Share

Report

Posted on by RJF61

1,265

I have a Flow that utilizes the following in the the Filter Query of a Get items.

Created ge ' @{formatDateTime(addDays(utcNow(),-6 , 'yyyy-MM-dd'))} '

When the Flow ran on Friday 2022-08-05 at 4:00 PM, I assumed it would get all records greater than or equal to 2022-07-30 through 2022-08-05. After review of the records, it appears that the 25 records entered on 2022-08-05 were not included.

Am I misunderstanding the date process?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

@RJF61 What is your timezone? Is it significantly different from UTC time?

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

Like (0)

Report
Copy link

Link copied!

@takolota My timezone is EST. 4 hours different from UTC.

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

@RJF61 Then I don’t immediately know why it might do that, unless those records were created after the flow run on Friday.

Was this reply helpful? Yes No