On 7/16/24 08:57, Anthony Apollis wrote:
> That very same code is picking up all the data in the Original Table.
> Which only contains past data.
It would.
select CURRENT_DATE;
current_date
--------------
2024-07-16
"Date" < CURRENT_DATE
would return data < 2024-07-16.
You want data that has dates > 2024-07-16.
--
Adrian Klaver
adrian.klaver@aklaver.com