topic Re: Date formatting in QlikView https://community.qlik.com/t5/QlikView/Date-formatting/m-p/456305#M170345 <HTML><HEAD></HEAD><BODY><P>I tried that as soon as I finished writing this post and yes, it works, many thanks</P></BODY></HTML> Fri, 25 Jan 2013 04:00:34 GMT 2013-01-25T04:00:34Z Date formatting https://community.qlik.com/t5/QlikView/Date-formatting/m-p/456303#M170343 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am having trouble with the formatting of date.</P><P>The source is currently in this format</P><P>yyyy/mm/dd - session number, e.g, 2010/06/30 - 406</P><P>I am trying to create a master calendar with this date field.</P><P></P><P>I removed the session number from the field using subfield, and I am left with the date.</P><P>I want the date to be DD/MM/YY, so i use the Date function;</P><P>Date(SUBFIELD(SessionDate,'-',1),'DD/MM/YYYY') AS NewDate but while the session number is successfully removed, the format remains unchanged. </P><P></P><P>Anyone can help?</P></BODY></HTML> Fri, 25 Jan 2013 03:09:32 GMT https://community.qlik.com/t5/QlikView/Date-formatting/m-p/456303#M170343 2013-01-25T03:09:32Z Re: Date formatting https://community.qlik.com/t5/QlikView/Date-formatting/m-p/456304#M170344 <HTML><HEAD></HEAD><BODY><P>Try the following:</P><P></P><P>Date(Date#(Trim(SubField(SessionDate,'-')),'YYYY/MM/DD'),'DD/MM/YYYY') as NewDate</P></BODY></HTML> Fri, 25 Jan 2013 03:19:20 GMT https://community.qlik.com/t5/QlikView/Date-formatting/m-p/456304#M170344 nagaiank 2013-01-25T03:19:20Z Re: Date formatting https://community.qlik.com/t5/QlikView/Date-formatting/m-p/456305#M170345 <HTML><HEAD></HEAD><BODY><P>I tried that as soon as I finished writing this post and yes, it works, many thanks</P></BODY></HTML> Fri, 25 Jan 2013 04:00:34 GMT https://community.qlik.com/t5/QlikView/Date-formatting/m-p/456305#M170345 2013-01-25T04:00:34Z