topic Re: Date Format in QlikView https://community.qlik.com/t5/QlikView/Date-Format/m-p/497989#M1126175 <HTML><HEAD></HEAD><BODY><P>works perfect,</P><P>thanks</P></BODY></HTML> Sun, 12 Jan 2014 08:06:46 GMT Anonymous 2014-01-12T08:06:46Z Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/497987#M1126173 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>The date field in my model starts well on the Raw-data section (01/09/2013 14:10:00), but in the Dw it goes out of format and looks like that:41518.590277778.</P><P>is there a magic spell to keep it in date format?</P><P></P><P>thanks</P><P>avner</P></BODY></HTML> Sun, 12 Jan 2014 07:04:04 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/497987#M1126173 Anonymous 2014-01-12T07:04:04Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/497988#M1126174 <HTML><HEAD></HEAD><BODY><P>Try:&nbsp; <SPAN class="Bold">timestamp(<EM>yourfield</EM>, 'MM/DD/YYYY hh:mm:ss')</SPAN></P></BODY></HTML> Sun, 12 Jan 2014 07:50:38 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/497988#M1126174 albertovarela 2014-01-12T07:50:38Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/497989#M1126175 <HTML><HEAD></HEAD><BODY><P>works perfect,</P><P>thanks</P></BODY></HTML> Sun, 12 Jan 2014 08:06:46 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/497989#M1126175 Anonymous 2014-01-12T08:06:46Z