Use something like as below, here prism:expirationDate represents expiration date, and using properties lower bound and upper bound you can define the date range. select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/metadata/prism:expirationDate] > cast('2017-03-22T07:00:00.000...