How to generate Month Names

[Anonymous]

I want Monthnames to show only Jan, Feb etc....Its showing Jan 2011, Feb 2011 as of now as shown in the image below.

This is my current script below:

let start = floor(date(AddMonths('2013-12-31',-35)));

let end = floor(date('2013-12-31'));

let numofdays = end - start+1;

Time_table:

LOAD

Distinct

AutoNumberHash128(MonthName(date($(start)+ RowNo() -1))) as Month_Seq,

This is my current script. Thanks

MonthName(date($(start)+ RowNo() -1)) as Month_name,

YearName(date($(start)+ RowNo() -1)) as Year,

date($(start)+ RowNo() -1)as Date

AutoGenerate $(numofdays);

[Anonymous · Accepted solution]

Try using the Month() function instead of MonthName()

[Anonymous]

Thanks Bill.

here is the correct complete syntax:

1) Month(date($(start)+ RowNo() -1)) as Month,

2) Monthname(date($(start)+ RowNo() -1)) as Month_name,

1) will display Jan and 2 will Jan 2011.

[its_anandrjs]

Yes you are right see this also

let start = floor(date(AddMonths('2013-12-31',-35)));
let end = floor(date('2013-12-31'));
let numofdays = end - start+1;

LOAD
Distinct
AutoNumberHash128(MonthName(date($(start)+ RowNo() -1))) as Month_Seq,
MonthName(date($(start)+ RowNo() -1)) as Month_name,
Month(date($(start)+ RowNo() -1)) as Months,
YearName(date($(start)+ RowNo() -1)) as Year,
date($(start)+ RowNo() -1)as Date
AutoGenerate $(numofdays);

Regards

Anand