topic Re: Time stamp in QlikView https://community.qlik.com/t5/QlikView/Time-stamp/m-p/648229#M474818 <HTML><HEAD></HEAD><BODY><P><SPAN style="background-color: rgba(255, 255, 255, 0);">"2014/the following in my scriot05/21 12:09:22 PM"</SPAN></P><P>?</P><P></P><P>Copy issue?</P></BODY></HTML> Tue, 26 Aug 2014 06:51:59 GMT MarcoWedel 2014-08-26T06:51:59Z Time stamp https://community.qlik.com/t5/QlikView/Time-stamp/m-p/648226#M474815 <HTML><HEAD></HEAD><BODY><P>Morning All,</P><P></P><P>I have a bit of an unusual time stamp that just wont cooperate. The date looks like this "2014/the following in my scriot05/21 12:09:22 PM" and I am trying to use the following in my script: " Floor(Timestamp#(gps_conf_Location_Time,'YYYY/MM/DD hh:mm:ss TT'),'YYYY/MM/DD') as ADate" but is just not converting to a date, can anyone throw in some suggestions?</P><P></P><P>Thank you</P><P></P><P>H</P></BODY></HTML> Tue, 26 Aug 2014 06:16:04 GMT https://community.qlik.com/t5/QlikView/Time-stamp/m-p/648226#M474815 2014-08-26T06:16:04Z Re: Time stamp https://community.qlik.com/t5/QlikView/Time-stamp/m-p/648227#M474816 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P><STRONG>Date(</STRONG>Floor(Timestamp#(gps_conf_Location_Time,'YYYY/MM/DD hh:mm:ss TT')<STRONG>)</STRONG>,'YYYY/MM/DD') as ADate</P></BODY></HTML> Tue, 26 Aug 2014 06:22:49 GMT https://community.qlik.com/t5/QlikView/Time-stamp/m-p/648227#M474816 tresB 2014-08-26T06:22:49Z Re: Time stamp https://community.qlik.com/t5/QlikView/Time-stamp/m-p/648228#M474817 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>can you post some sample date.</P><P></P><P>Regards,</P></BODY></HTML> Tue, 26 Aug 2014 06:23:38 GMT https://community.qlik.com/t5/QlikView/Time-stamp/m-p/648228#M474817 PrashantSangle 2014-08-26T06:23:38Z Re: Time stamp https://community.qlik.com/t5/QlikView/Time-stamp/m-p/648229#M474818 <HTML><HEAD></HEAD><BODY><P><SPAN style="background-color: rgba(255, 255, 255, 0);">"2014/the following in my scriot05/21 12:09:22 PM"</SPAN></P><P>?</P><P></P><P>Copy issue?</P></BODY></HTML> Tue, 26 Aug 2014 06:51:59 GMT https://community.qlik.com/t5/QlikView/Time-stamp/m-p/648229#M474818 MarcoWedel 2014-08-26T06:51:59Z Re: Time stamp https://community.qlik.com/t5/QlikView/Time-stamp/m-p/648230#M474819 <HTML><HEAD></HEAD><BODY><P>Perfect, Thanks</P></BODY></HTML> Tue, 26 Aug 2014 06:54:36 GMT https://community.qlik.com/t5/QlikView/Time-stamp/m-p/648230#M474819 2014-08-26T06:54:36Z