How to select particular data from multiple document where starting date should not be below the current date?
In N1QL QUERY
Thanks
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);
1 Like
This works very well. thank you