Hi All ,
I have a Date and Time field in my CDT (type DATE in the Oracle database). This field has a date and a time. I create a query entity rule with the filter:
a!queryFilter(field: "recertificationDate",operator: "=",value: ri!recertificationDate,applyWhen: not(rule!APN_isBlank(ri!recertificationDate)))
In the database, I have records with the date and time of 4/15/2019 4:05 PM but when I test my rule with ri!recertificationDate = 4/15/2019 4:05 PM, the rule is returning NO records. Any ideas why this is happening?
Discussion posts and replies are publicly visible