Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I've a master calendar. I need Month_Year format (Jan2016,Feb2016 and so on...)
How to achieve this?
MasterCalendar:
Load
TempDate AS DATE,
week(TempDate) As Week,
Year(TempDate) As Year,
Month(TempDate) As Month,
Day(TempDate) As Day,
'Q' & ceil(month(TempDate) / 3) AS Quarter,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
WeekDay(TempDate) as WeekDay
;
//=== Generate a temp table of dates ===
LOAD
date(mindate + IterNo()) AS TempDate
,maxdate // Used in InYearToDate() above, but not kept
WHILE mindate + IterNo() <= maxdate;
//=== Get min/max dates from Field ===/
LOAD
YearStart(FieldValue('DATE', recno()))-1 as mindate,
YearEnd(FieldValue('DATE', recno())) as maxdate
AUTOGENERATE FieldValueCount('DATE');
monthname(Datefield)
monthname(Datefield)