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
Consider making a view against your Oracle table.In the view, add a column that extrapolates the date only from the date time field.
then filter on the new date column.
Hi Robert, I don't think that is the problem because I even changed the CDT field from a Date and Time to a DATE and I ran a SQL to convert the database table column values from date and time to date and when I applied the date filter (instead of date and time), it still did not work. Any ideas why this might be happening?
Did you consider Timezone difference between the value that you are inputting and the timezone stored in the DB?