cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
martinav
Resident Rockstar
Resident Rockstar

How to write ODATA filter for date inequality

So simple... but not:

 

Input data:

 

image.png

 

Flow Action, which obviously does not work.  Please help.

image.png

f

1 REPLY 1
Piper
Resolver II
Resolver II

This might be the answer (but you won't like it).  Please review the Sql Server Connector Documentation

 

In the Known Issues and Limitations it states specific data types that cannot be used in query option predicates.  Also, a bit lower it states "Direct date filters do not work for SQL Server." There may be a work around if you can create a calculated field in Sql Server.

 

DataTypes.PNG

 

DateFilter.PNG

 

WorkAround.PNG

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

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

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (36,784)