problem with date format

[P_qlik]

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 · Accepted solution]

HI @P_qlik 

Try like below

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

[P_qlik]

Thank you!