Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. LOAD
  2. TempDate AS OrderDate,
  3. Week (TempDate) AS Week,
  4. Year (TempDate) AS Year,
  5. Month (TempDate) AS Month,
  6. Day (TempDate) AS Day,
  7. Weekday (TempDate) AS WeekDay,
  8. 'Q' & Ceil(Month (TempDate)/3) AS Quarter,
  9. Date( Monthstart (TempDate), 'MMM-YYYY') AS MonthYear,
  10. Week (TempDate) & '-' & Year (TempDate) AS WeekYear,
  11. Year(YearStart(TempDate,0,0)) as FiscalYear
  12. Resident TempCalendar
  13. Order by TempDate ASC;
  14.  
  15. Drop Table TempCalendar;
  16.  
  17. Qualify MonthYear;
  18. Duplicate:
  19. Load MonthYear as [Month Year]
  20. Resident MasterCalendar;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement