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

[KevinBiehl]

"$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.

[Hannah_B]

Hi @KevinBiehl , 

Thank you for reaching out. On this API board, we support AccountRight and Essentials. For help with the MYOB Advanced API, we recommend that you drop an email to the MYOB Advanced API Team at advancedisvs@myob.com. Or visit there website http://developer.myob.com/api/advanced/ 

Many Thanks,

[bretto36]

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.

---