1

With the help of M Bain I found a solution, because the number of monthes are only 6, 12, 24 and 35. So I did i like this and choosed for the special dates the last existing date: case when day( "date")='31' and month( "date" ) ='03' and "months"=6 then to_date(concat(year("date"), '-09-30' ) ) when day( "date")='31' and month( "date" ) ='05' and "...


Only top voted, non community-wiki answers of a minimum length are eligible