Issue while fetching date from query rule

What is the Column type for that column?

Datatype :DATE

I have a filter for dateTime and it works fine:

a!queryFilter(
applyWhen: not(isnull(ri!requestsNewerThan)),
field: "createdOn",
operator: ">",
value: ri!requestsNewerThan
)

I would say that the rule input and filtered field both need to be date/datetime).

You can not save date and time on data type field. Can you share us more details on DB structure and values?

can you try adding these filters to your rule and check if it helps

{
a!queryFilter(
  field: "date",
  operator: ">=",
  value: todatetime(ri!date)
),
a!queryFilter(
  field: "date",
  operator: "<=",
  value: todatetime(ri!date)+1
)
}

First of all, DB won't allow to save DATETIME value in DB when the column type is DATE.