Back to all

Querying "LastModifyDate" using $GT is returning Error

Since the webhooks are not fully implemented, I am trying to query opportunities that have been updated since a stored date. The idea is that we store the date and time of the last check and the retrieve it to use in the query.

    "Criteria": {
      "SearchQuery": {
        "LastModifyDate": {
          "$GT": "2026-04-13T00:49:38Z"
        }
      }
    }

The schema reports that it 'is' queryable:

    "Queryable": [
      "$EQ",
      "$NE",
      "$GT",
      "$GE",
      "$LT",
      "$LE",
      "$RANGE",
      "$NRANGE"
    ]

But the response I get is:

{
  "Code": -4,
  "Msg": [
    {
      "Message": "Query: Operator \"$GT\" is not supported for property \"LastModifyDate\" in { LastModifyDate $GT 2026-04-13T00:49:38Z } [MaAccess\\Maximizer.Data].",
      "ErrorCode": -40002
    }
  ]
}

Is there an issue with my syntax or what?