X axis date formatting on chat.

[#1]

I have below dates on X-axis

• 08/14/2011
• 07/09/2011
• 06/08/2011
• etc.

How to format these in Month-yyyy format or dd-mm-yyyy format.

Thanks in advance for help.

[MayilVahanan · Accepted solution]

Hi,

     In Script,

     You can change like this,

     Load *,Month(Date) & ' -' & Year(Date) as MonthYear from tablename;

     Month('08/14/2011') & ' -' & Year('08/14/2011') gives Aug-2011

     Hope it helps

[#3]

Thanks formated my axis using your below suggestion-

Month('08/14/2011') & ' -' & Year('08/14/2011') gives Aug-2011