cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nick9one1
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

nick9one1_0-1610908733097.png

 

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

 

{"@odata.etag":"","ItemInternalId":"d97ef8c5-8c75-4ffc-8359-c65941818d91","ImplementationDate":"2020-03-30T00:00:00Z"}

 

 

5 REPLIES 5
ChristianAbata
Super User
Super User

hi @nick9one1 could you try with eq 

 

Solved: Filter SQL Date field issue - Power Platform Community (microsoft.com)

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



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 www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
fchopo
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 (microsoft.com)

 

Hope it helps!

Ferran

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

nick9one1_0-1610961100301.png

 

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

Regards,

Ferran

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'

or

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. 

 

nick9one1_1-1610963394486.png

 

Helpful resources

Announcements
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)