cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jonathanO
Advocate II
Advocate II

Compare Datetime error for Get Rows Filter

I am using a SQL Get Rows action that connects to an on premise SQL instance.

 

I have the filter set up like this:

filterQuery_datetime_compare.PNG

 

This results in the error:

flow_datetime_comparision_query.PNG

 

 

Any idea on why i am getting this error and what the best way to compare datetime is?

2 REPLIES 2
v-micsh-msft
Community Support
Community Support

Hi @jonathanO,

 

Could you please explain a bit for the Odata Query formula, why adding the minutes () function after the day function?

I tested it from my side (on premise SQL Server) and it works:

44.PNG

 

Would you please try it again?

 

Further, if the issue insists, please post the running detail URL, which should contain the FLow and the Runs GUID.

For example:

https://asia.flow.microsoft.com/manage/environments/Default-9e51064f-f6a5-41a2-89a9-9785a9d6c706/

flows/77c37940-4734-4c8f-9XXXX66b734/

runs/085869252612XXXX47256941063

?backUrl=%2Fflows%2F77c37940-4734-4c8f-97cb-e872b366b734%2Fdetails&runStatus=Succeeded

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (64,885)