Forum Discussion

KevinBiehl's avatar
KevinBiehl
5 years ago

MYOB Advanced API - unable to run the following query "$filter": "LastModifiedDateTime ge '2020-10-10T11:00:00'"

"$filter": "LastModifiedDateTime ge '2020-10-10T11:00:00'"   what should be right datetime format?   "message": "An error has occurred.", "exceptionMessage": "A binary operator with incompatible...
bretto36's avatar
bretto36
4 years ago

For anyone else having this issue this is the valid way to filter by date

 

ShipmentDate gt datetimeoffset'2020-07-27T00:00:00Z'

KevinBiehl wrote:

"$filter": "LastModifiedDateTime ge '2020-10-10T11:00:00'"

 

what should be right datetime format?

 

"message": "An error has occurred.",
"exceptionMessage": "A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.String' for operator kind 'GreaterThanOrEqual'.",

 as error message.

 

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.