I am trying to do a query to get a result that includes all objects created in between 2 dates. So far I have something like this. SELECT * FROM c WHERE c.partitionID >= '%-2021-07-07% AND c.partitionID < '%-2021-12-20%'

My Objects look like this:

{
    "u_id": "698719sd9618",
    "client_id": "097",
    "entry_time": "27/8/2021 05:05:11",
    "partitionID": "097-2021-08-27T01",
}
{
    "u_id": "2ERRT719sd9618",
    "client_id": "096",
    "entry_time": "28/8/2021 05:05:11",
    "partitionID": "097-2021-08-28T01",
}
{
    "u_id": "24arYUI4214",
    "client_id": "095",
    "entry_time": "20/11/2021 05:05:11",
    "partitionID": "097-2021-11-20T01",
}
{
    ...
}