CQL search query is not returning the proper result for between the Last modified date.

[sase apiqa]

Hi Team ,

We are using the CQL to get the file modified details , it not returning immediate results but same query return the result after 24 hours . 

Some time not given proper results as well. 

CQL: lastmodified >= "2023/05/24+15:54" and lastmodified < "2023/05/29+07:12"

Please help us to resolve the issue, let us know any required changes we have to do. 

CQL: lastmodified >= "2023/05/24+15:54"

Results :Correct results.

lastmodified >= "2023/05/24+15:54" and lastmodified < "2023/05/29+07:12"

Result: Wrong Results

[Aron Gombas _Midori_]

Are you sure that those '+' characters between the date and the time are necessary?

The official guide shows this example:

lastmodified >= 2014-09-01 and lastmodified < "2014-09-03 09:00"

 There is no '+' there...