Colocar Trimestre no calendário

[Ribeiro]

Calenderio:

LOAD Distinct Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY') AS CalendarDate,

month(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS CalendarMês,

WeekDay(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS CalendarSemana,

Day(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS CalendarDia,

year(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS CalendarAno,

monthname(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS CalendarMonthname

AutoGenerate 1 While $(vDateMin) + IterNo() - 1 <=$(vDateMax);

Como inserir Trimestre acima.

ceil(Month(Data_Alteracao)/3)&'Trim' as CalendarTrimestre

[maxgro · Accepted solution]

let vDateMin=floor(Makedate(2015));

let vDateMax=floor(makedate(2016));

Calenderio:

LOAD

Distinct

ceil(Month(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY'))/3) & 'Trim' as CalendarTrimestre,

Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY') AS CalendarDate,

month(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS CalendarMês,

WeekDay(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS CalendarSemana,

Day(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS CalendarDia,

year(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS CalendarAno,

monthname(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS CalendarMonthname

AutoGenerate 1 While $(vDateMin) + IterNo() - 1 <=$(vDateMax);