Hi, How can I skip empty/null values as my dob property has empty ("") string for some of the documents and below error is giving error XDMP-LEXVAL: xs.date("") -- Invalid lexical value "" Query: cts.search(cts.andQuery([cts.jsonPropertyRangeQuery("dob", '>', fn.currentDate().subtract(xs.yearMonthDuration("P25Y"))),cts.collectionQuery("col-1")]));
And Q2: Any sample for group-by age by extracting date from dob? Thanks Shan.
_______________________________________________ General mailing list General@developer.marklogic.com Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general