Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LOAD
- TempDate AS OrderDate,
- Week (TempDate) AS Week,
- Year (TempDate) AS Year,
- Month (TempDate) AS Month,
- Day (TempDate) AS Day,
- Weekday (TempDate) AS WeekDay,
- 'Q' & Ceil(Month (TempDate)/3) AS Quarter,
- Date( Monthstart (TempDate), 'MMM-YYYY') AS MonthYear,
- Week (TempDate) & '-' & Year (TempDate) AS WeekYear,
- Year(YearStart(TempDate,0,0)) as FiscalYear
- Resident TempCalendar
- Order by TempDate ASC;
- Drop Table TempCalendar;
- Qualify MonthYear;
- Duplicate:
- Load MonthYear as [Month Year]
- Resident MasterCalendar;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement