String or Number to Date Format

[#1]

Hi All,

I need to convert " 200011" to Year and Month Format like this " Nov  2000".

I tried this

=

Date# (01012001, 'MMM YYYY')

but it not working. Is there any way to do this.

Thanks,

Selva

[Gysbert_Wassenaar · Accepted solution]

Try date(date#('200011','YYYYMM'),'MMM YYYY')

[#3]

try this

date(DATE#('200011','YYYYMM'),'MMM YYYY')

[pennetzdorfer]

You need to use date#() to convert the string into a date and than use date() get the desired format:

date(date#(200011,'YYYYMM'),'MMM YYYY')

Also see the examples in the Qlikview Manual ...

Hope that helps!

Regards,

Florian

[sujeetsingh]

Selva,

See the attached file .

I have done a logical change and scripting in script of the qvw.

Hope it help you,

[RedSky001]

You may also find this link usefull (I know did) http://community.qlik.com/docs/DOC-3102

[#7]

Thankyou all.. Everyone on the same line...