pass through filter for a Postgres database source

[Bob09]

the table has a timestamp column "lastupdttms" 

how do you specify to excude records where the "lastupdttms" is older than 14 days on the FULL Load?

[Bob09]

I can get it to work it I hard code the date:  lastupdttms >= '2024-01-15'

but I wanted it to be based on the retrieving the current date/time

[miTsirraH · Accepted solution]

Maybe try this:

lastupdttms  >= CURRENT_DATE - 14

[Dana_Baldwin]

Hi @Bob09 

These two knowledge articles should help:

Filter for last 90 days of data in Qlik Replicate - Qlik Community - 1880761

Filter for last 90 days of data in Qlik Replicate ... - Qlik Community - 1980009

Dana