topic Re: Date difference in QlikView https://community.qlik.com/t5/QlikView/Date-difference/m-p/467080#M1163871 <HTML><HEAD></HEAD><BODY><P>I got it....I changed Number format to Interval and changed Pattern......Thanks</P></BODY></HTML> Mon, 26 Nov 2012 18:58:48 GMT 2012-11-26T18:58:48Z Date difference https://community.qlik.com/t5/QlikView/Date-difference/m-p/467079#M1163870 <HTML><HEAD></HEAD><BODY><P>I have two date fields in mm/dd/yyyy hh:mi:ss PM format.......</P><P></P><P>I want to caluculate the difference in same format........</P><P></P><P>I am using interval function</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style=": ; color: #0000ff; font-size: 8pt;"></SPAN></SPAN></P><P>interval</P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">StartDate</SPAN><SPAN style="font-size: 8pt;">-</SPAN><SPAN style="color: #800000; font-size: 8pt;">Enddate</SPAN><SPAN style="font-size: 8pt;">, 'dd hh:mi:ss' ) </SPAN><P></P><P>I am getting result as dd hh:mm:ss</P><P></P><P></P><P>But in minutes place I am getting&nbsp; mi(i).....</P><P></P><P>How to eliminate i and get exact minutes.......</P></BODY></HTML> Mon, 26 Nov 2012 18:48:48 GMT https://community.qlik.com/t5/QlikView/Date-difference/m-p/467079#M1163870 2012-11-26T18:48:48Z Re: Date difference https://community.qlik.com/t5/QlikView/Date-difference/m-p/467080#M1163871 <HTML><HEAD></HEAD><BODY><P>I got it....I changed Number format to Interval and changed Pattern......Thanks</P></BODY></HTML> Mon, 26 Nov 2012 18:58:48 GMT https://community.qlik.com/t5/QlikView/Date-difference/m-p/467080#M1163871 2012-11-26T18:58:48Z