Hi @Tonny,
SQL++ for CB Lite supports array and date operations. You can go with an approach similar to the one shown in this blog post.
Another option might be to use the full text search to perform date range queries. For reference on using full text search with couchbase lite, you can check this question on the forum: Weird behaivor from CB Lite Full Text Search on string lists