Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
P_qlik
Partner
Partner

problem with date format

Hi,

I have this formula: =max([YYYYMM]) and the result is 202104

I need to have it in this format: april 2021

I've tried this formula: =date(max([YYYYMM]), 'MMMM YYYY') but the result is not correct:  may 2453

How can I do?

Thank you

1 Solution

Accepted Solutions
MayilVahanan

HI @P_qlik 

Try like below

Date(Date#(max([YYYYMM]), 'YYYYMM'),'MMM YYYY')

Thanks & Regards,
Mayil Vahanan R

View solution in original post

2 Replies
MayilVahanan

HI @P_qlik 

Try like below

Date(Date#(max([YYYYMM]), 'YYYYMM'),'MMM YYYY')

Thanks & Regards,
Mayil Vahanan R

View solution in original post

P_qlik
Partner
Partner
Author

Thank you!