Issue while fetching date from query rule

What is the Column type for that column?

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).

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.