Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

MonthYear help

Hi Experts,

Can any one please help me to convert the below Monthyear field from Text format to actual Motnhyear in Backend.

in the List box MonthYear is at left side because its in Text format and Max(MonthYear) is also not working.

Please help me on this.

Monthyear.png

1 Solution

Accepted Solutions
Ivan_Bozov
Valued Contributor

Re: MonthYear help

Try like this:

DATE(DATE#(DateField, 'MMM YYYY'), 'MM.YYYY') AS DateField

1 Reply
Ivan_Bozov
Valued Contributor

Re: MonthYear help

Try like this:

DATE(DATE#(DateField, 'MMM YYYY'), 'MM.YYYY') AS DateField