Forums
Querying "LastModifyDate" using $GT is returning Error
yesterday by Jeff Brown
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?