Date Format

[krishna20]

Hi Friends,

I'm having a problem in Retrieving the date format.

I'm having the field Ret_Month and need to use it as dimension.

My Ret_Month is in 01,02,03,04......

I need show like it as full names January....December.

I used like below.

=if(date(Ret_Month,'MMMM'),Ret_Month)

But, i'm getting as January, December, January, January,January......January.

Please anyone suggest me what may be the problem is...

Thanks & Regards

Krishna

[SunilChauhan]

simply suggets to use

Load * inline [

Ret_Month ,fullmonth,

01,Janauray

02,February

03,March

04,April

05,May

06,Jun

07,July

08,August

09,September

10,November

11,December

];

use fullmonth in place of RetMonth in Charts

[ecolomer]

here you are

[ashfaq_haseeb · Accepted solution]

Have a look at attached application.

Edit:

You can even use the below code too.

Date(Date#(MONTH,'MM'),'MMMM') as TestField,

Regards

ASHFAQ

[MarcoWedel]

Hi Krishna,

as far as I can see, Manish Kachhia was the first who came up with the

Date(Date#(SubField('$(MonthNames)',';',Ret_Month),'MMM'),'MMMM') as Ret_MonthFull

solution.

regards

Marco

[krishna20]

Thank You,

Manish

[MK_QSL]

Thanks Marco for pointing this out...

Community Members satisfaction is more important for me rather than Earning Point.

As far as this question closed... I am happy...