topic Re: Date format 20130924183259.301 in QlikView https://community.qlik.com/t5/QlikView/Date-format-20130924183259-301/m-p/490683#M183319 <HTML><HEAD></HEAD><BODY><P>try this also,</P><P>num(Timefield_name)</P></BODY></HTML> Sat, 28 Sep 2013 06:22:19 GMT 2013-09-28T06:22:19Z Date format 20130924183259.301 https://community.qlik.com/t5/QlikView/Date-format-20130924183259-301/m-p/490681#M183317 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I have date in my database in this format</P><P>20130924183259.301</P><P>and when I load it in QV then it becomes</P><P>41541.7729050926</P><P>Can you please help me with converting</P><P>41541.7729050926</P><P>to</P><P>20130924183259.301</P><P></P><P>I am using TimeStamp () which returns me '9/24/2013 6:32:59 PM' and omitting the millisecond part.</P><P>Thanks,</P><P>Saurabh</P></BODY></HTML> Fri, 27 Sep 2013 23:02:56 GMT https://community.qlik.com/t5/QlikView/Date-format-20130924183259-301/m-p/490681#M183317 2013-09-27T23:02:56Z Re: Date format 20130924183259.301 https://community.qlik.com/t5/QlikView/Date-format-20130924183259-301/m-p/490682#M183318 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>timestamp(FIELD,'YYYYMMDDhhmmss.fff')</P></BODY></HTML> Fri, 27 Sep 2013 23:57:11 GMT https://community.qlik.com/t5/QlikView/Date-format-20130924183259-301/m-p/490682#M183318 swuehl 2013-09-27T23:57:11Z Re: Date format 20130924183259.301 https://community.qlik.com/t5/QlikView/Date-format-20130924183259-301/m-p/490683#M183319 <HTML><HEAD></HEAD><BODY><P>try this also,</P><P>num(Timefield_name)</P></BODY></HTML> Sat, 28 Sep 2013 06:22:19 GMT https://community.qlik.com/t5/QlikView/Date-format-20130924183259-301/m-p/490683#M183319 2013-09-28T06:22:19Z