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",
}
{
...
}