Discussion board where members can get started with Qlik Sense.
My date filed in CSV is like "Monday, March 14, 2016" , Please suggest a function in Qlik to read it as date?
Go to Solution.
Date(Date#(datefield, 'WWWW, MMMM DD, YYYY'))
ApplyMap( 'MonthName',PurgeChar(subfield([Date_Created],',',2),' 0123456789')),
KeepChar(subfield([Date_Created],',',2),'0123456789')) as [Transcation Date],