MasterCalendar:
LOAD
floor(TempDate) as $(fieldname)
,date(TempDate) as Дата
,Day(TempDate) as День
,WeekDay(TempDate) as [День недели]
,week(TempDate) as [Номер недели]
,Month(TempDate) as Месяц
,MonthName(TempDate) as Период
,'К' & ceil(month(TempDate) / 3) as Квартал
и т.п
;
LOAD
floor(mindate + IterNo()) AS TempDate
,floor(maxdate) as maxdate
,floor(mindate) as mindate
While mindate + IterNo() <= maxdate;
LOAD
min(FieldValue('$(fieldname)', recno()))-1 as mindate
,max(FieldValue('$(fieldname)', recno())) as maxdate
AutoGenerate FieldValueCount('$(fieldname)');