to get month name and year from month

[#1]

in dimension i have month field, but in the source as month as i have the format as 1/1/2016

but in the chart i want the axis to show as Jan 16

how do we do ? please help

[CELAMBARASAN]

Use MonthName(FieldName) in Dimension.

Or you can create this as new field in script to get used in multiple charts.

[sarvesh]

Hi.. Sona,

Use this code:

Date(Date#(yourdatefield,'DD/MM/YYYY'),'MMM YY') as yourdatefield

and make sure your MonthNames variable is set correctly to interpret the month names

[Miguel_Angel_Baeyens]

Or even easier, if this works for you, use

MonthName(DateField) AS MonthName

In your script rather than MonthName() in the expression, although it will work as well.

[ramasaisaksoft]

=Date(today(),'MMMYY')

=Date(FieldName,'MMMYY')

it will gives you Mar17

If you feel your issue is solved please close the thread  by clicking "Correct Answer"

[sarvesh]

Please close the thread, if your problem has been resolved.