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

[ecolomer]

You need to see the SET sentence in the begining script .... and see the QV  file attached

[MK_QSL]

Load

  *,

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

Inline

[

  Ret_Month

  01

  02

  03

  04

  05

  06

  07

  08

  09

  10

  11

  12

];

[ashfaq_haseeb]

Hi,

Can you post a sample qvw file.

Regards

ASHFAQ

[ecolomer]

Attaced a Qv file

[krishna20]

Hi Colomer,

i used the expression which you suggested me.but its not working.

regards

Krishna

[ashfaq_haseeb]

Post your sample file.

Regards

ASHFAQ

[ecolomer]

Get me the QV file to see

In my QV they are another file xls in charge script

Here you have all

[MarcoWedel]

Maybe also:

Date#(SubField('$(LongMonthNames)',';',Ret_Month),'MMMM')

?

Regards

Marco

[krishna20]

Hi Colomer,

Please find the below attachment and guide me further.

Regards

Krishna