Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
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.

View solution in original post

4 Replies
sujeetsingh
Master III
Master III

Try using date#

Not applicable
Author

Try Date#

rwunderlich
Luminary Alumni
Luminary Alumni

=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.

View solution in original post