Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below dates on X-axis
How to format these in Month-yyyy format or dd-mm-yyyy format.
Thanks in advance for help.
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
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
Thanks formated my axis using your below suggestion-
Month('08/14/2011') & ' -' & Year('08/14/2011') gives Aug-2011