@ryuhayabusa3540

i havent started on this,  but i will start from week 0 and see if i can solve everything on me own

@mohamed.montaser

when i did it your way it gave an error " Column "n" not found; " , 
it only worked for me this way
WITH dates (n) AS
(
SELECT cast( '2023-01-01' as date )
union all
SELECT dateadd(day, 1, n) from dates where n < dateadd(day,-1,now()) 
)
SELECT * FROM dates;