Get data by comparing the date


#1

How to select particular data from multiple document where starting date should not be below the current date?
In N1QL QUERY
Thanks


#2

You can use any date functions listed in https://developer.couchbase.com/documentation/server/current/n1ql/n1ql-language-reference/datefun.html
Assume your dates are stored in ISO 8601 format

Example:
SELECT … FROM default WHERE SUBSTR(startdate,0,10) > SUBSTR(NOWS_STR(),0,10);


#3

This works very well. thank you