How to write Between Query in N1QL?

How to write Between Query in N1QL

ex: select * from bucketName where key=‘abcd’ AND (startDate >= ‘2016-07-07T18:00:00’ AND endDate<= ‘2016-07-09T23:59:00’)

like that i have written but the result is coming wrong.

That looks correct. In what way is the result wrong? Can you post a couple of sample documents? What is the difference between the result you are getting and the result you are expecting?

Hi Geraldss,

Thanks for your reply as you said this query is correct. I identified the issue and fixed. That was problem with bucket.

1 Like