Hello 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
Hi ericp,
Could you please specify the type of the rule input recertificationDate?
recertificationDate is of type date and time.
Did you try changing the rule input type to DATE and see if it is fetching the matching records?
I can't pass date because I specifically need records where recertificationDate = 4/15/2019 4:05 PM. If I change it to date, it will be looking for records where the field = 4/15/2019 and that will be incorrect (I also think it will not work because my CDT has the field as date and time).