Re: Code does Not Read in FY 2025 Data

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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