reading long dates into Qlik

[guruprem]

Hi,

My date filed in CSV is like "Monday, March 14, 2016" , Please suggest a function in Qlik to read it as date?

[guruprem]

makedate(subfield([Date_Created],',',3),

     ApplyMap( 'MonthName',PurgeChar(subfield([Date_Created],',',2),' 0123456789')),

     KeepChar(subfield([Date_Created],',',2),'0123456789'))  as [Transcation Date],

[rwunderlich · Accepted solution]

Date(Date#(datefield, 'WWWW, MMMM DD, YYYY'))

-Rob

http://masterssummit.com

http://qlikviewcookbook.com