Filter with dates

[bill-chartrand-rgare]

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]

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 

 DesmondWOO 

 Support

[john_wang]

Hello @bill-chartrand-rgare ,

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:

https://community.qlik.com/t5/Qlik-Replicate/Pass-thru-filter/td-p/2411372

Hope this helps.

John.

[DesmondWOO]

Hi @bill-chartrand-rgare ,

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 · Accepted solution]

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.