Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a field date whit this format
201801, 201802, ....
when i create the Master Calendar just recognize 3 dates:
This is the scrip i use in the MasterCalendar
TABLA_CALENDARIO:
NoConcatenate
Load
Periodo
Resident CKM3N;
//--------------------------------------//
// SETEO DE VARIABLES PARA EL CALENDARIO//
//--------------------------------------//
LET varMinDate = Num(Peek('Periodo', 0, 'TABLA_CALENDARIO'));
LET varMaxDate = Num(Peek('Periodo', -1, 'TABLA_CALENDARIO'));
DROP TABLE TABLA_CALENDARIO;
//*************** Temporary Calendar ***************
TempCalendar:
LOAD
$(varMinDate) + rowno()-1 AS Num,
DATE($(varMinDate) + rowno()-1) AS TempDate
AUTOGENERATE
$(varMaxDate)- $(varMinDate)+ 1;
//*************** Master Calendar ***************
MasterCalendar:
LOAD
AutoNumber(TempDate) AS [key_Año_Mes],
TempDate,
month(TempDate) AS Month,
year(TempDate) AS Year,
Month(TempDate) AS MesCalen,
date(monthstart(TempDate), 'MMM-YYYY') AS MesAño
RESIDENT TempCalendar
ORDER BY TempDate Asc;
DROP TABLE TempCalendar;
Thx for all the help
Try this
TABLA_CALENDARIO:
NoConcatenate
Load Min(Date#(Periodo, 'YYYYMM')) as Min,
Max(Date#(Periodo, 'YYYYMM')) as Max,
Resident CKM3N;
//--------------------------------------//
// SETEO DE VARIABLES PARA EL CALENDARIO//
//--------------------------------------//
LET varMinDate = Num(Peek('Min'));
LET varMaxDate = Num(Peek('Max'));
DROP TABLE TABLA_CALENDARIO;
Try this
TABLA_CALENDARIO:
NoConcatenate
Load Min(Date#(Periodo, 'YYYYMM')) as Min,
Max(Date#(Periodo, 'YYYYMM')) as Max,
Resident CKM3N;
//--------------------------------------//
// SETEO DE VARIABLES PARA EL CALENDARIO//
//--------------------------------------//
LET varMinDate = Num(Peek('Min'));
LET varMaxDate = Num(Peek('Max'));
DROP TABLE TABLA_CALENDARIO;
It work's, Thx a lot