I have requirement where i need to use querybuilder daterange redicate to search data based on data properties. Issue that i am facing is metadata of content have inconsistent date format so i can not use one specific date format in date range property.
E.g. when i use daterange.lowerBound=2019-12-28T00:00:00.000-05:00 then it does not fetch content which have date as 2019-12-28T00:07:19.558Z and vice cersa.
Is there a way so that i can fetch all records irrespective of date format?
Solved! Go to Solution.