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

Convert a number to date

Hi guys,

I need your help to convert a number like 200903 to date format, how to do that?

I used date function: date(cur_date, 'YYYYMM'), cur_date variable has values of 200903, 200904...somthing like that. However I got 245001 as a result...Anyone knows why?

Thanks a lot!

1 Solution

Accepted Solutions
PrashantSangle

Hi,

As all Say Date#() will help you

You use like this way

Date(Date#(YourDateFieldName,'YYYYMM'),'MMM-YYYY')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

4 Replies
sujeetsingh
Master III
Master III

Try using date#

Not applicable
Author

Try Date#

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

=date(date#('200903'),'YYYYMM'))

-Rob

PrashantSangle

Hi,

As all Say Date#() will help you

You use like this way

Date(Date#(YourDateFieldName,'YYYYMM'),'MMM-YYYY')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂