Forum Discussion

KevinBiehl's avatar
4 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 types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.String' for operator kind 'GreaterThanOrEqual'.",

 as error message.

2 Replies

Replies have been turned off for this discussion
  • 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.