cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ahowes Helper I
Helper I

gt and lt work great for utcnow in flow, but eq does not. I assume it's a formatdate issue? How to write?

Hi- I am brand new to flow/automate and have had great success building flows with gt and lt TODAY. I cannot get eq TODAY to work however.

 

I assume it's because of a date formatting issue because it is probably returning minutes in addition to day and therefore there is no EXACT match?

 

If so, how do I write the query to also format the returned date to only include day?

 

Here is my current query: Created eq 'addDays(utcNow(),-9)'

 

Thanks!

3 REPLIES 3
Super User
Super User

Re: gt and lt work great for utcnow in flow, but eq does not. I assume it's a formatdate issue? How to write?

This seems like a Power Automate question. Suggest you post this at the Power Automate community:
https://powerusers.microsoft.com/t5/General-Power-Automate/bd-p/MPAForum

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com
ahowes Helper I
Helper I

Re: gt and lt work great for utcnow in flow, but eq does not. I assume it's a formatdate issue? How to write?

Thank you...I thought I was there, must have clicked the wrong shortcut. Have a great weekend!

Super User
Super User

Re: gt and lt work great for utcnow in flow, but eq does not. I assume it's a formatdate issue? How to write?

No worries at all! Have a great weekend!

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,884)