I want to update an attribute’s status of my couchbase json document based on the date ; if the date is less than my desired date the attribute’s status should be changed .
Currently using this Query but it is not working and date format is DD-MM-YYYY
test set recordstatus= “1”
WHERE (SUBSTR(UpdateDate,0,2)||"-"||SUBSTR(UpdateDate,3,2)||"-"||SUBSTR(UpdateDate,6,4)) <
Thanks in advance