Solved: Re: problem with date format - Qlik Community

P_qlik · ‎2021-04-27

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

MayilVahanan · ‎2021-04-27

Try like below

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

MayilVahanan · ‎2021-04-27

Try like below

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

P_qlik · ‎2021-04-27

Thank you!