Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

String or Number to Date Format

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

1 Solution

Accepted Solutions

Re: String or Number to Date Format

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


talk is cheap, supply exceeds demand
6 Replies

Re: String or Number to Date Format

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


talk is cheap, supply exceeds demand
Not applicable

Re: String or Number to Date Format

try this

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

pennetzdorfer
Contributor III

Re: String or Number to Date Format

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
Honored Contributor III

Re: String or Number to Date Format

Selva,

See the attached file .

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

Hope it help you,

msheraton
Contributor III

Re: String or Number to Date Format

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

Not applicable

Re: String or Number to Date Format

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

Community Browser