Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

get rows with sql date filter error

I'm trying to filter a SQL table so it only shows items in the next 7 days. 

I cant seem to get a very simple filter to work at the moment. 


ImplementationDate ge '2020-03-30T00:00:00Z'


I get this error



With no filter it works. the output for each item looks like this;





Super User
Super User

hi @nick9one1 could you try with eq 


Solved: Filter SQL Date field issue - Power Platform Community (

Solved: Get a error using utcNow() in SQl get rows - Power Platform Community (

Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!

If you want you can follow me at Quieres contenido en español? Síguenos en Power Automate LA
Super User
Super User

Hello @nick9one1 

Could you use the following expression?:

ImplementationDate ge date(2020-03-30T00:00:00Z)

You can find another thread with a similar issue and an excellent solution posted by @abm : Solved: SQL GetRows OData Date Filter - Power Platform Community (


Hope it helps!


Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

That looks very promising, although it does exactly the same..



replacing ge with eq appears to work, but the result is what looks like just a JSON header with no data


Hello @nick9one1 

Just a couple of questions:

1) Which version of SQL Server are you using?

2) Is this an On-premise instance or an Azure one?

3) Are you calling a stored procedure? (I read something like ImplementationDate in the Select Query field).



Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

If I use the above example with eq the result is this;

ImplementationDate eq '2019-08-29T00:00:00Z'


ImplementationDate eq date(2019-08-29T00:00:00Z')


the date selected should return more than one item. but it doesn't seem to return any. 




Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,010)