Table- year days

[abTech]

I have those two tables already loaded, I need to calculate the "number of days " in 2023 for each match and the number of days in 2024 also for each match in a table chart, note that there is matches start in 2023 and end in 2024.

Attendees ID Table t

Attendees Table

[madelonjansen]

You could create a record for every 'Match Day', with the actual date. 

Then it is the year of that date, versus the number of date records.

Try this:

Load *,
    Year(Match_Date)                        as Match_Year
;
Load *,
    Date(Start_Date + Iterno()-1)       as Match_Date
Resident Match_Table
While Date(Start_Date + Iterno()-1) <= End_Date;