Re: Code does Not Read in FY 2025 Data

On 7/16/24 08:15, Anthony Apollis wrote:

Reply to list also
Ccing list

> i did attached the sample data.

Yes I know and the data for 2025  will fail because they are like this:

Date FY    Period    Quarter    Day    Month    Year    Loaddate
2025-01-10 00:00:00.000    NULL    NULL    NULL    10    1    2025    2023-07-10 11:55:09.733

The FY values are NULL and they will not be found by:

"FY" IS NOT NULL AND "FY" >= 'FY24'

For the updated data that is for 2026 and 2027 there are FY values, but 
then you do:

WEEK_NUMBER."Date" < CURRENT_DATE

where WEEK_NUMBER is the alias for the sub-select that filtered on:

"FY" IS NOT NULL AND "FY" >= 'FY24'

So even if the sub-select found values in the future you filter them out 
  with < CURRENT_DATE

-- 
Adrian Klaver
adrian.klaver@aklaver.com