topic Re: Converting time out of a date stamp in App Development https://community.qlik.com/t5/App-Development/Converting-time-out-of-a-date-stamp/m-p/59057#M3915 <HTML><HEAD></HEAD><BODY><P>That worked great, thanks Bill!</P></BODY></HTML> Tue, 20 Feb 2018 21:12:22 GMT joe_mccorkel 2018-02-20T21:12:22Z Converting time out of a date stamp https://community.qlik.com/t5/App-Development/Converting-time-out-of-a-date-stamp/m-p/59055#M3913 <HTML><HEAD></HEAD><BODY><P>Hello- I am tryilng to convert the time section of a date stamp that looks like '20180129060000' to be 6:00:00AM, or '20180129235900' to be 23:59:00/ 11:59PM. Ive tried using date(rignt('date',6)) and date(date#(right('date',6))). the first returns 12:00:00AM every time, and the second returns null. Any thoughts?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 20 Feb 2018 20:59:11 GMT https://community.qlik.com/t5/App-Development/Converting-time-out-of-a-date-stamp/m-p/59055#M3913 joe_mccorkel 2018-02-20T20:59:11Z Re: Converting time out of a date stamp https://community.qlik.com/t5/App-Development/Converting-time-out-of-a-date-stamp/m-p/59056#M3914 <HTML><HEAD></HEAD><BODY><P>Try something like:</P><P></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; ==time(time#(right(20180129235900,6),'hhmmss'),'h:mm:ss TT')</EM></P></BODY></HTML> Tue, 20 Feb 2018 21:05:42 GMT https://community.qlik.com/t5/App-Development/Converting-time-out-of-a-date-stamp/m-p/59056#M3914 Anonymous 2018-02-20T21:05:42Z Re: Converting time out of a date stamp https://community.qlik.com/t5/App-Development/Converting-time-out-of-a-date-stamp/m-p/59057#M3915 <HTML><HEAD></HEAD><BODY><P>That worked great, thanks Bill!</P></BODY></HTML> Tue, 20 Feb 2018 21:12:22 GMT https://community.qlik.com/t5/App-Development/Converting-time-out-of-a-date-stamp/m-p/59057#M3915 joe_mccorkel 2018-02-20T21:12:22Z