How to extract Month and Monthyear from Date field?

[mahitham]

Hi,

Can any one please help me to extract Month and Month year from below Date field. Here some dates are showing left side and some are showing at right side. Due to this Month() is not working. 

Thanks in advance

[Taoufiq_Zarra]

@mahitham  you can test :

 Month(MakeDate('20'&right(subfield(Date,'/',3),2),subfield(Date,'/',1),subfield(Date,'/',2))) as NewDateFieldMonth

or

Month(Date(
    Floor(
        Alt(
         Num(Date), 
         Num(Date#(Date, 'MM/DD/YYYY')),
         Num(Date#(Date, 'MM/DD/YY'))
         )), 'MM/DD/YYYY')) as NewDateFieldMonth

[Chanty4u]

i have created one blog for multiple date formats. please have a look.

https://community.qlik.com/t5/Qlik-Sense-Documents/Multiple-Dates-Using-Alt/ta-p/1493744

or try this

table1:

date(Date#(Datefield),'MM/dd/yyyy') as ConverttoNumber;

date(alt(Datefield),'MM/dd/yyyy') as Newdate;

https://ezdatamunch.com/use-simple-date-functions-qlikview-qliksense/