Greater than equal to not working as expected

Hello,

I have a requirement where i need to query ids with approvedOn date greater than or equal to (today - 5) business days.

What i have in place is working only for equal to but not for greater than.

Any inputs?

index(
        rule!ACO_getCdt( 
          entity: cons!TEST,
          type: 'type!{urn:com:appian:types:occrcl}Test?list',
          fields: {"transactionId"},
          filters: {
            rule!ACO_filterEquals(field:"transactionId", value: 501),
            rule!ACO_filterEquals(field:"isApproved", value:true),
            rule!ACO_filterEquals(field:"actionId", value:cons!OCC_RCL_REF_TRANSACTION_ACTION_APPROVE_RECLASS_ID),
            /*constant has -5 value*/
            rule!ACO_filterGreaterThanOrEqualTo(field:"approvedOn", value: gmt(todatetime(workday(rule!ACO_today(), cons!OCC_RCL_AWAITING_APPROVAL_FINAL_NOTIFICATION_REMINDER_DAYS)))),               
            rule!ACO_filterLessThanOrEqualTo(field:"approvedOn", value: gmt(todatetime(workday(rule!ACO_today(), cons!OCC_RCL_AWAITING_APPROVAL_FINAL_NOTIFICATION_REMINDER_DAYS))) + intervalds(23,59,59)) 
          }
        ),
        "transactionId",
        {}
      )
      
      ================================
      rule!ACO_filterGreaterThanOrEqualTo():
      rule!ACO_queryFilter(
  field: ri!field,
  operator: ">=",
  value: ri!value
)

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data