MonthYear help

[mahitham]

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.

[Ivan_Bozov · Accepted solution]

Try like this:

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