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;
@ryuhayabusa3540