Hi list, I'd like to generate the latest year dynamically with generate_series. This select works day wise: select date_trunc ('month', now())::date + s.a from generate_series(0, 11) as s(a) I tried this but it didn't work: select date_trunc ('month', now())::date + interval s.a || ' months' from generate_series(0, 11) as s(a) This works but looks grotesque: select distinct date_trunc ('month', now()::date + s.a)::date from generate_series(0, 365) as s(a) Is there a way to do this more elegantly? Best regards, Marcus