1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| LET vDateMin = Num(MakeDate(2000,1,1));
LET vDateMax = Floor(YearEnd(AddMonths(Today(), 12)));
LET vDateToday = Num(Today());
TempCalendar:
LOAD
$(vDateMin) + RowNo() - 1 AS DateNumber,
Date($(vDateMin) + RowNo() - 1) AS TempDate
AUTOGENERATE 1
WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);
MasterCalendar:
LOAD
TempDate AS Date,
Day(TempDate) AS Jour,
WeekDay(TempDate) AS SemaineJour,
Week(TempDate) AS Semaine,
Month(TempDate) AS Mois,
Year(TempDate) AS Année,
'Q' & Ceil(Month(TempDate)/3) AS Trimestre,
WeekDay(TempDate) & '-' & Year(TempDate) AS SemaineAnnée,
Month(TempDate) & '-' & Year(TempDate) AS MoisAnnée
RESIDENT TempCalendar ORDER BY TempDate ASC;
DROP TABLE TempCalendar;
LET vDateMin = Num(MakeDate(2000,1,1));
LET vDateMax = Floor(YearEnd(AddMonths(Today(), 12)));
LET vDateToday = Num(Today()); |
Partager