Hi,
I think i understand your logic.
Try this:
[SCADENZIARIO]:
LOAD
SCADUTIOLTRE120,
SCADUTI120,
SCADUTI90,
SCADUTI60,
SCADUTI30,
ASCADERE30,
ASCADERE60,
ASCADERE90,
ASCADERE120,
...
...;
SQL SELECT
year(XLSCAD)*100+Month(XLSCAD) "Annomese",
case when XLSCAD < (current date - 5 month) then 1 else 0 end as "SCADUTIOLTRE120",
case when XLSCAD >= (current date - 5 month) and XLSCAD < (current date - 4 Month) then 1 else 0 end as "SCADUTI120",
case whenXLSCAD >= (current date - 4 month) and XLSCAD < (current date - 3 month) then 1 else 0 end as "SCADUTI90",
case when XLSCAD >= (current date - 3 month) and XLSCAD < (current date - 2 month) then 1 else 0 end as "SCADUTI60",
case when XLSCAD >= (current date - 2 month) and XLSCAD < (current date - 1 month) then 1 else 0 end as"SCADUTI30",
case when XLSCAD >= (current date -1 month) and XLSCAD < (current date + 1 month) then 1 else 0 end as"ASCADERE30",
case when XLSCAD >= (current date + 1 month) and XLSCAD < (current date + 2 month) then 1 else 0 end as"ASCADERE60",
case when XLSCAD >= (current date + 2 month) and XLSCAD < (current date + 3 month) then 1 else 0 end as"ASCADERE90",
case when XLSCAD >= (current date + 3 month) then 1 else 0 end as"ASCADERE120",
....
....;
you have to verify the intervals for XLSCAD
