topic Date Field in QlikView https://community.qlik.com/t5/QlikView/Date-Field/m-p/463300#M1165686 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a date field that looks like:</P><P></P><P>[End Date]</P><P>1-May-2012</P><P>3-June-2008</P><P>5-April-2007</P><P></P><P></P><P>Tried to format it so i can pull the year by itself but didn't work. Year([End Date])</P><P>I tried to do :</P><P>Date#([End Date]) as Date, </P><P>Date( Date#( [End Date], 'MM/DD/YYYY' ) ) as Date,</P><P></P><P>Both options didn't work. Any idea?</P><P></P><P>Thxs for your help,</P><P>Alec</P></BODY></HTML> Mon, 29 Oct 2012 17:04:13 GMT alec1982 2012-10-29T17:04:13Z Date Field https://community.qlik.com/t5/QlikView/Date-Field/m-p/463300#M1165686 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a date field that looks like:</P><P></P><P>[End Date]</P><P>1-May-2012</P><P>3-June-2008</P><P>5-April-2007</P><P></P><P></P><P>Tried to format it so i can pull the year by itself but didn't work. Year([End Date])</P><P>I tried to do :</P><P>Date#([End Date]) as Date, </P><P>Date( Date#( [End Date], 'MM/DD/YYYY' ) ) as Date,</P><P></P><P>Both options didn't work. Any idea?</P><P></P><P>Thxs for your help,</P><P>Alec</P></BODY></HTML> Mon, 29 Oct 2012 17:04:13 GMT https://community.qlik.com/t5/QlikView/Date-Field/m-p/463300#M1165686 alec1982 2012-10-29T17:04:13Z Re: Date Field https://community.qlik.com/t5/QlikView/Date-Field/m-p/463301#M1165688 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Please check the attached file</P></BODY></HTML> Mon, 29 Oct 2012 17:07:18 GMT https://community.qlik.com/t5/QlikView/Date-Field/m-p/463301#M1165688 MayilVahanan 2012-10-29T17:07:18Z Re: Date Field https://community.qlik.com/t5/QlikView/Date-Field/m-p/463302#M1165689 <HTML><HEAD></HEAD><BODY><P>Hi Alec,</P><P></P><P>The second parameter of the DATE#() function is the mask used to interpret the field value. In your case, it would be:</P><P><EM>DATE(DATE#([End Date], 'D-MMMM-YYYY')) AS [End Date]</EM></P><P></P><P>Regards.</P></BODY></HTML> Mon, 29 Oct 2012 17:11:16 GMT https://community.qlik.com/t5/QlikView/Date-Field/m-p/463302#M1165689 diegofcaivano 2012-10-29T17:11:16Z Re: Date Field https://community.qlik.com/t5/QlikView/Date-Field/m-p/463303#M1165690 <HTML><HEAD></HEAD><BODY><P>Thxs guys!</P></BODY></HTML> Mon, 29 Oct 2012 17:16:38 GMT https://community.qlik.com/t5/QlikView/Date-Field/m-p/463303#M1165690 alec1982 2012-10-29T17:16:38Z