how to extract year from date with timestamp from jcr:property of a page using querybuilder api aem

[krupesh_4129]

I have two filters on page viz. Year & Category. Based on this filters i need to retrieve the pages from the repository and show it on the page. I am using querbuilder api to fetch the pages based on searching "year & category" properties in the page property of the list of pages.However, I have a date property in page properties of list of pages from where i need to compare the year filter of my query. But filter=year is in the format "2017" & date=timestamp in pageproperties of page is in format of "2017-09-18T01:15:00.000+05:30". So how do i compare the year filter & date in page properties to fetch these particular pages through my query.

query map: 
  if (StringUtils.isNotBlank(year)) {
  map.put("3_property", "year");
  map.put("3_property.value", 2017);
  }

page property:

[viveksachdeva]

Take a look at Search DAM assets and Cq pages using lastModified date | QueryBuilder . It used DateRangePredicateEvaluator (Day Communique 5.4 Java Documentation 5.4.0-SNAPSHOT API)

[krupesh_4129 · Accepted solution]

Got the solution.

map.put("daterange.property", "date"); //Since the property name is date as per your image.
map.put("daterange.lowerBound", year + "-01-01"); //First day of the year
map.put("daterange.upperBound", year + "-12-31"); //Last day of the year