topic Re: Filter with dates in Qlik Replicate

Filter with dates

bill-chartrand-rgare — Wed, 18 Sep 2024 17:00:45 GMT

Trying to add a filter condition based on a date and getting issues with the query that is being submitted.

Here is my filter:

Here is the query that I see being submitted:

(TRUNCATED THE STATEMENT)

...FROM "SCHEMA"."TABLE" WHERE (("IF_DATE" >= TO_DATE('0000-00-00','YYYY-MM-DD')))' (oracle_endpoint_utils.c:1941)

How do I get this to submit the date that I am actually putting on the front end?

BHR — Wed, 18 Sep 2024 20:49:23 GMT

Bill,

I did check out the linked article Filter data in the table with date column in Qlik replicate task - the example in the comments on that one did have the data formatted YYYY-MM-DD - it was a comment from

john_wang — Thu, 19 Sep 2024 01:22:05 GMT

There are 3 different types of filters in Qlik Replicate, you can use one, or multipe of them in the task. Please check my comment in below article:

Hope this helps.

John.

DesmondWOO — Thu, 19 Sep 2024 04:54:00 GMT

If you need to express the date in 'mm-dd-yyyy' format, you'll have to use the passthru filter.

Filter Conditions:
The date must be in the format yyyy-mm-dd.

Expression Builder:
It appears that you'll need to separate the date into strings and then reassemble them.

Regards,
Desmond

bill-chartrand-rgare — Thu, 19 Sep 2024 12:22:38 GMT

We found the issue. When we used '2024-07-01' it wouldn't process it correctly. The date needed to be without ' ', so 2024-07-01 worked.

Kohila — Thu, 13 Nov 2025 20:49:20 GMT

How to have the filter in passthrough when I have the date field as timestamp like '2012-09-04 00:00:00.000"

I have to apply filter in both CDC and full load to load the data after 2020-01-01. Can anyone help on this?

Kohila — Thu, 13 Nov 2025 20:49:39 GMT

and my source and target is oracle