Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

guruprem
Contributor III

reading long dates into Qlik

Hi,

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

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: reading long dates into Qlik

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

2 Replies
guruprem
Contributor III

Re: reading long dates into Qlik

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

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

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

MVP & Luminary
MVP & Luminary

Re: reading long dates into Qlik

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com