Month Year Format

[#1]

Hi all,

I am using below load script,

Month(weekend(CanonicalDate)) as MonthPeriod,

This will print only the month name as 'NOV'

But i need like Nov-15.

So i used

Month(weekend(CanonicalDate)) & '-' & Year(CanonicalDate,'YY') as MonthPeriod

But not working.

Help on this.

Regards,

Kumar

[MK_QSL]

Try below

Date(MonthStart(weekend(CanonicalDate)),'MMM-YY') as MonthPeriod

[tresesco]

MonthName(CanonicalDate) ?

[sat_tok52]

Date(MonthStart(CanonicalDate),'MMM-YY')

[umartareen]

Hi,

You can use

Monthname(CanonicalDate) as FieldName

[saumyashah90]

as tresesco mentioned:

MonthName(CanonicalDate)  will work