Hi Tanika, Thanks for the solution but again this does not work for the query builder daterange as it works on UTC format not the one that is stored in crxde. Is there a way I can use the daterange to search irrespective of any timezone, i.e., the date which is stored in crxde.