Discussion Board for collaboration related to QlikView App Development.
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?
Try like below
Date(Date#(max([YYYYMM]), 'YYYYMM'),'MMM YYYY')
View solution in original post