Number searcher not filtering by more or less than

[Miguel Zapata]

Number searcher not filtering by more or less

I created a script custom field with this code to get the hour for created issues

{code:js}
import java.util.Calendar

Calendar cal = Calendar.getInstance();
TimeZone tz = TimeZone.getTimeZone("GMT-3");
cal.setTimeZone(tz);
cal.setTime(issue.created);
cal.get(Calendar.HOUR_OF_DAY)
{code}

When I search for issues, this JQL is not giving results

project = PS AND created >= startOfWeek(-1) AND TimeOfDay >23 AND TimeOfDay <7

Custom field configuration is number searcher

[Payne]

Your logic is flawed; a number cannot be both > 23 and < 7.

[Miguel Zapata]

Yeah, I was thinking like a human, just to reply to my own question what I did was.

project = PS AND created >= startOfWeek(-1) AND TimeOfDay >=23 

OR

project = PS AND created >= startOfWeek(-1) AND TimeOfDay <=7

Which worked perfect.