Guest User

Untitled

a guest
Nov 18th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. Kalender:
  2. Load
  3. TempDate AS [Issue Datum],
  4. Year(TempDate) As Jahr,
  5. Month(TempDate) As Monat,
  6. monthname(TempDate) as [Monat Jahr],
  7. Day(TempDate) As Tag,
  8. 'Q' & ceil(month(TempDate) / 3) AS Quartal,
  9. 'Q' & ceil(month(TempDate) / 3) & ' ' & Year(TempDate) AS [Quartal Jahr],
  10. Dual('KW' & Week(weekstart(TempDate)), Week(weekstart(TempDate))) as Woche,
  11. Dual('KW' & Week(weekstart(TempDate)) & ' ' & WeekYear(TempDate), weekstart(TempDate)) as [Woche Jahr],
  12. WeekDay(TempDate) as WeekDay
  13. ;
  14.  
  15. //=== Generate a temp table of dates ===
  16. LOAD
  17. date(mindate + IterNo()) AS TempDate
  18. ,maxdate // Used in InYearToDate() above, but not kept
  19. WHILE mindate + IterNo() <= maxdate;
  20.  
  21. //=== Get min/max dates from Field ===/
  22. LOAD
  23. min(FieldValue('Issue Datum', recno()))-1 as mindate,
  24. max(FieldValue('Issue Datum', recno())) as maxdate
  25. AUTOGENERATE FieldValueCount('Issue Datum');
Add Comment
Please, Sign In to add comment