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.