Hi There - 

I don't know if this group is still active, I'm having trouble trying to query resources by date. For instance, using this query to get sales orders:

mydomain.com/.../***/SO_SalesOrderHeader

The query parameters I've tried:

• ?where=DateUpdated gt 2016-01-01
• ?where=DateUpdated gt '2016-01-01'
• ?where=DateUpdated gt @2016-01-01@
• ?where=$updated gt '2016-01-01'
• ?where=$updated gt @2016-01-01@

None of them work. I'm getting variations of the following errors depending on the date format I use:

• ERROR [37000] [ProvideX][ODBC Driver]Expected lexical element not found: <identifier>
• ERROR [S0000] [ProvideX][ODBC Driver]Invalid operand for operator: >

I'm able to get individual results querying any other column except dates (by the key or name for instance) or every record in the resource. That happens also for different resources (Item, Customer, etc.). 

I'm just consuming the data (I'm working on an e-commerce integration), I'm not the one that setup the server. I'm starting to believe there's something wrong with the server setup.

Any suggestions? 

Thank you.

Daniel M.