@kolipakularaviturnkey
Are you sure your data in identity is always correct and consistent with the given date format, if that’s case
Also how is this Stored in DB level as String or a epoch time format?
If possible, can you please share sample identity from debug page
If you are using Filter DataSource in the report I don’t think there is a direct way to do this unless you have another field at Identity level with date type ( that gets synced with a rule based on this date)
Can you share your report task definition xml, I think using java data source this is achievable without creating an identity attribute.
Other experts can comment if they have any other alternative
Hi @kolipakularaviturnkey, you can try like this… String startDate= “01/01/2021 13:27:44”;
QueryOptions options = new QueryOptions();
Calendar cal = Calendar.getInstance();
Date currentDate = cal.getTime();
Long currentMilis = cal.getTimeInMillis();
SimpleDateFormat sf = new SimpleDateFormat(“MM/dd/yyyy HH:mm:ss”);
Date d = sf.parse(startDate);
cal.setTime(d);
Date launchTimeDate = cal.getTime();
Long launchTime = cal.getTimeInMillis();
Filter f1 = Filter.gt(“created”, launchTimeDate);
Filter f2 = Filter.lt(“created”, currentDate);
Filter fr = Filter.and(f2,f1);
options.addOrdering(“created”, true);
options.addFilter(fr);
log.debug("Options Filter: "+options);
Iterator it = context.search(Identity.class, options);
while (it.hasNext()) {