Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
sush_1
Partner - Contributor III
Partner - Contributor III

Record selection conditions

Hi team,

We need filter out data during cdc for only last two months. Records needs to be pushed for last two months only older date data should not be reflected.

Filter to be added on the basis of created_date and modified_date

Please help us in getting filter setup during cdc

1 Solution

Accepted Solutions
DesmondWOO
Support
Support

Hi @sush_1 ,

You can add a filter expression like 

$created_date >= datetime('now', 'localtime', '-2 months')

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!

View solution in original post

1 Reply
DesmondWOO
Support
Support

Hi @sush_1 ,

You can add a filter expression like 

$created_date >= datetime('now', 'localtime', '-2 months')

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!