Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
bill-chartrand-rgare
Contributor II
Contributor II

Filter with dates

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

Here is my filter:

billchartrandrgare_0-1726678616376.png

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?

 

billchartrandrgare_1-1726678655771.png

 

1 Solution

Accepted Solutions
bill-chartrand-rgare
Contributor II
Contributor II
Author

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.

View solution in original post

4 Replies
BHR
Contributor III
Contributor III

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 

BHR_0-1726692550866.png

 

  
 Support
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
DesmondWOO
Support
Support

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



Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
bill-chartrand-rgare
Contributor II
Contributor II
Author

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.