Master Calender

[upaliwije]

calender:

LOAD

    Date(T_DATE) AS T_DATE,

    Year(T_DATE) AS T_YEAR,

    Month(T_DATE) As T_MONTH;

  Load Date(T_MinDate + IterNo() -1 ) AS T_DATE While (T_MinDate + IterNo() - 1) <= Num(T_MaxDate);

Load

    Min(T_DATE) AS T_MinDate,

    Max(T_DATE) AS T_MaxDate

RESIDENT sales;

I have created the above master calender. I want to add YEAR-MON field to the above calender.

Please help me to add the code for it in the above script

[giakoum · Accepted solution]

Year(T_DATE) & Month(T_DATE) As T_YEAR_MONTH

[#3]

Try :

dual(year(T_DATE) & '-' & month(T_DATE),

year(T_DATE) & num(month(T_DATE), '00')) as T_YearMonth,