How to get MonthYear format?

MuraliPrasath — Wed, 25 Nov 2020 16:16:04 GMT

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');

Re: How to get MonthYear format?

shraddha_g — Thu, 15 Dec 2016 05:27:12 GMT

monthname(Datefield)