Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

try this

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

pennetzdorfer
Creator III
Creator III

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
Master III
Master III

Selva,

See the attached file .

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

Hope it help you,

RedSky001
Partner - Creator III
Partner - Creator III

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

Not applicable
Author

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