topic problem with date format in QlikView

problem with date format

P_qlik — Tue, 27 Apr 2021 10:35:46 GMT

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 — Tue, 27 Apr 2021 10:51:51 GMT

Try like below

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

P_qlik — Tue, 27 Apr 2021 10:54:12 GMT

Thank you!