Help needed with COQL query

Help needed with COQL query

Hi all,

I'm facing an issue with the v2 COQL query. Can someone resolve the issue?

Query
  1. select Dossier, Status, Toekenning_startdatum, Toekenning_einddatum, Created_Time from Bijzondere_bijstanden where Dossier in (640049000000603044,640049000000550726) AND ((Toekenning_startdatum between '2024-01-01' and '2024-12-31') OR (Toekenning_einddatum between '2024-01-01' and '2024-12-31') OR (Created_Time between '2024-01-01' and '2024-12-31')) limit 200
Error
  2. {
  3.     "code": "SYNTAX_ERROR",
  4.     "details": {
  5.         "near": "where"
  6.     },
  7.     "message": "error occured while parsing the query",
  8.     "status": "error",
  9.     "$responseHeaders": {
  10.         "x-ratelimit-remaining": null,
  11.         "x-ratelimit-limit": null,
  12.         "x-ratelimit-reset": null
  13.     }
  14. }

Thank you all for helping me.

Greetings,
Justin