Re: Code does Not Read in FY 2025 Data

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@aklaver.com