That very same code is picking up all the data in the Original Table. Which only contains past data.
On Tue, 16 Jul 2024 at 17:39, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 7/16/24 08:28, Anthony Apollis wrote:
> Only data up until 2024 is picked up in Revised table, whic contains
> 2025 data. THe Maxdate calculation seems to be the problem.
This:
'Only data up until 2024 is picked up in Revised table, whic contains
2025 data. .."
is consistent with:
MaxDate AS (
SELECT
MAX("Date") AS "MaxDate"
FROM
FullWeeks
WHERE
"Date" < CURRENT_DATE
)
I don't see how you expect to fetch data from the future when you limit
the data to the past.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
