topic Re: Format Timestamp by Hour in App Development https://community.qlik.com/t5/App-Development/Format-Timestamp-by-Hour/m-p/1201025#M22772 <HTML><HEAD></HEAD><BODY><P>Or even this:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Timestamp(Floor(Frac([Interaction Start Date Time UTC]), 1/24), 'h TT')</STRONG></P></BODY></HTML> Mon, 17 Oct 2016 17:13:17 GMT sunny_talwar 2016-10-17T17:13:17Z Format Timestamp by Hour https://community.qlik.com/t5/App-Development/Format-Timestamp-by-Hour/m-p/1201023#M22770 <HTML><HEAD></HEAD><BODY><P>I would like to show data by hour 12am - 12pm.&nbsp; The expression below works, but I would like to display the PM time as 1pm, 2pm, 3pm, etc. instead of 13pm, 14pm, 15pm, etc. </P><P></P><P>Any suggestions on how to update to adjust the timestamp for the PM hours?&nbsp; </P><P></P><P>Timestamp([Interaction Start Date Time UTC], 'h') &amp; Timestamp([Interaction Start Date Time UTC],'TT') </P></BODY></HTML> Mon, 17 Oct 2016 15:46:26 GMT https://community.qlik.com/t5/App-Development/Format-Timestamp-by-Hour/m-p/1201023#M22770 2016-10-17T15:46:26Z Re: Format Timestamp by Hour https://community.qlik.com/t5/App-Development/Format-Timestamp-by-Hour/m-p/1201024#M22771 <HTML><HEAD></HEAD><BODY><P>How about this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Timestamp([Interaction Start Date Time UTC], 'h TT')</STRONG></SPAN></P><P></P><P>or</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Timestamp(Floor([Interaction Start Date Time UTC], 1/24), 'h TT')</STRONG></SPAN></P></BODY></HTML> Mon, 17 Oct 2016 17:12:04 GMT https://community.qlik.com/t5/App-Development/Format-Timestamp-by-Hour/m-p/1201024#M22771 sunny_talwar 2016-10-17T17:12:04Z Re: Format Timestamp by Hour https://community.qlik.com/t5/App-Development/Format-Timestamp-by-Hour/m-p/1201025#M22772 <HTML><HEAD></HEAD><BODY><P>Or even this:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Timestamp(Floor(Frac([Interaction Start Date Time UTC]), 1/24), 'h TT')</STRONG></P></BODY></HTML> Mon, 17 Oct 2016 17:13:17 GMT https://community.qlik.com/t5/App-Development/Format-Timestamp-by-Hour/m-p/1201025#M22772 sunny_talwar 2016-10-17T17:13:17Z