AEM Query date range

[krist_wang]

I have a query as below:

type=cq:Page
path=/content/ciandtamericaspartnersandboxprogram
tagid=astellas-news:press-releases
tagid.property=jcr:content/cq:tags

property=jcr:content/releaseTime
property.value=2023-10-09T13:44:00.000+08:00

p.limit=-1

and I want to find all pages under a certain year or month based on releaseTime, Can you help how I need to modify the query ?

Best regards!

[Mahedi_Sabuj · Accepted solution]

Hi @krist_wang, You need to use daterange predicate. 

daterange.property=jcr:content/releaseTime
daterange.lowerBound=2013-01-01
daterange.lowerOperation=>=
daterange.upperBound=2013-02-01
daterange.upperOperation=<=

https://experienceleague.adobe.com/docs/experience-manager-65/developing/platform/query-builder/quer... 

[kautuk_sahni]

@krist_wang Did you find the suggestions from @Mahedi_Sabuj helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.