topic pass through filter for a Postgres database source in Qlik Replicate https://community.qlik.com/t5/Qlik-Replicate/pass-through-filter-for-a-Postgres-database-source/m-p/2503615#M13596 <P>the table has a timestamp column "lastupdttms"&nbsp;</P> <P>how do you specify to excude records where the&nbsp;"lastupdttms" is older than 14 days on the FULL Load?</P> Wed, 29 Jan 2025 18:45:10 GMT Bob09 2025-01-29T18:45:10Z pass through filter for a Postgres database source https://community.qlik.com/t5/Qlik-Replicate/pass-through-filter-for-a-Postgres-database-source/m-p/2503615#M13596 <P>the table has a timestamp column "lastupdttms"&nbsp;</P> <P>how do you specify to excude records where the&nbsp;"lastupdttms" is older than 14 days on the FULL Load?</P> Wed, 29 Jan 2025 18:45:10 GMT https://community.qlik.com/t5/Qlik-Replicate/pass-through-filter-for-a-Postgres-database-source/m-p/2503615#M13596 Bob09 2025-01-29T18:45:10Z Re: pass through filter for a Postgres database source https://community.qlik.com/t5/Qlik-Replicate/pass-through-filter-for-a-Postgres-database-source/m-p/2503616#M13597 <P>I can get it to work it I hard code the date:&nbsp; lastupdttms &gt;= '2024-01-15'<BR /><BR />but I wanted it to be based on the retrieving the current date/time</P> Wed, 29 Jan 2025 18:52:58 GMT https://community.qlik.com/t5/Qlik-Replicate/pass-through-filter-for-a-Postgres-database-source/m-p/2503616#M13597 Bob09 2025-01-29T18:52:58Z Re: pass through filter for a Postgres database source https://community.qlik.com/t5/Qlik-Replicate/pass-through-filter-for-a-Postgres-database-source/m-p/2505061#M13666 <P>Maybe try this:<BR /><BR /><SPAN>lastupdttms&nbsp; &gt;=&nbsp;</SPAN>CURRENT_DATE - 14</P> Sun, 09 Feb 2025 01:48:51 GMT https://community.qlik.com/t5/Qlik-Replicate/pass-through-filter-for-a-Postgres-database-source/m-p/2505061#M13666 miTsirraH 2025-02-09T01:48:51Z Re: pass through filter for a Postgres database source https://community.qlik.com/t5/Qlik-Replicate/pass-through-filter-for-a-Postgres-database-source/m-p/2505210#M13667 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/164255">@Bob09</a>&nbsp;</P> <P>These two knowledge articles should help:</P> <P><A href="https://community.qlik.com/t5/Official-Support-Articles/Filter-for-last-90-days-of-data-in-Qlik-Replicate/ta-p/1880761" target="_blank">Filter for last 90 days of data in Qlik Replicate - Qlik Community - 1880761</A></P> <P><A href="https://community.qlik.com/t5/Official-Support-Articles/Filter-for-last-90-days-of-data-in-Qlik-Replicate-part-two/ta-p/1980009" target="_blank">Filter for last 90 days of data in Qlik Replicate ... - Qlik Community - 1980009</A></P> <P>Dana</P> Mon, 10 Feb 2025 15:21:25 GMT https://community.qlik.com/t5/Qlik-Replicate/pass-through-filter-for-a-Postgres-database-source/m-p/2505210#M13667 Dana_Baldwin 2025-02-10T15:21:25Z