cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ezequiel
Microsoft
Microsoft

Less than Date

Hi.

 

I have a SQL data extraction and I need to filter the table by a field called "StartDate". 

I tried: 

 

Capture.JPG

and the same adding ''

 

Capture.JPG

 

but none of those are working, getting the following error (If I remove the last filter everything works fine). How should I set the operator less than the Date field?

{
"error": {
"code": 502,
"source": "firstrelease-001.azure-apim.net",
"clientRequestId": "1821bc4e-2b9e-43bf-b1c1-ddcf8bc916b3",
"message": "The response is not in a JSON format."
}
}

5 REPLIES 5
abm
Super User
Super User

Hi @ezequiel 

 

What's your StartDate Format? Most likely you need to format your utcnow in that format. 

 

Check this post https://powerusers.microsoft.com/t5/General-Flow-Discussion/SQL-OData-UTC-Now/td-p/71005

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi,

 

This is the format of the field....any suggestion? Thanks!

 

Capture.JPG

 

Ezequiel

Hi @ezequiel 

 

Could you please post a screenshot of the startdate how it is stored in sql. If you don't have direct access then post a runtime history of sql data. This will show how the data is stored.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

@abmhere you go!

 

Capture.JPG

Thanks for your reply. Try to use this expression and compare formatDateTime(utcnow(), 'yyyy-MM-dd')



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,711)