topic Re: Timestamp format in QlikView https://community.qlik.com/t5/QlikView/Timestamp-format/m-p/53259#M788000 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>interval</STRONG>(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Timestamp#</STRONG>(END_TIME,'YYYYMMDDhhmmss')</SPAN> - Timestamp#(START_TIME,'YYYYMMDDhhmmss'),<STRONG>'hh:mm'</STRONG>)</SPAN></P></BODY></HTML> Tue, 20 Feb 2018 09:00:23 GMT tresB 2018-02-20T09:00:23Z Timestamp format https://community.qlik.com/t5/QlikView/Timestamp-format/m-p/53258#M787999 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Can any one please help me on converting below START TIME and END TIME to Time stamp like 2017-01-23 13:38:23(YYYY-MM-DD hh:mm:ss) from these need to calculate the duration like hh:mm</P><P>I have used the below expression but not working getting -.</P><P>Timestamp#(Timestamp(START_TIME,'YYYYMMDDhhmmss'),'YYYY-MM-DD hh:mm:ss')</P><P></P><P>Please help me on this</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Timestamp-format/m-p/53258#M787999 bhavvibudagam 2020-11-25T16:16:04Z Re: Timestamp format https://community.qlik.com/t5/QlikView/Timestamp-format/m-p/53259#M788000 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>interval</STRONG>(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Timestamp#</STRONG>(END_TIME,'YYYYMMDDhhmmss')</SPAN> - Timestamp#(START_TIME,'YYYYMMDDhhmmss'),<STRONG>'hh:mm'</STRONG>)</SPAN></P></BODY></HTML> Tue, 20 Feb 2018 09:00:23 GMT https://community.qlik.com/t5/QlikView/Timestamp-format/m-p/53259#M788000 tresB 2018-02-20T09:00:23Z