Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);