Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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
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/