topic Date Calculations in QlikView https://community.qlik.com/t5/QlikView/Date-Calculations/m-p/440911#M164351 <HTML><HEAD></HEAD><BODY><P>How do I calculate the number of days from today since a date in the format of <SPAN style="text-decoration: underline;"><STRONG>2/3/2012 1:55PM</STRONG></SPAN>?</P><P></P><P>And how do I calculate the number of days between two dates in these two different formats - format 1 <SPAN style="text-decoration: underline;"><STRONG>2/3/2012 1:55PM</STRONG></SPAN> and format 2 <STRONG style="text-decoration: underline;">12/12/2012 </STRONG>?</P></BODY></HTML> Thu, 14 Mar 2013 10:55:16 GMT 2013-03-14T10:55:16Z Date Calculations https://community.qlik.com/t5/QlikView/Date-Calculations/m-p/440911#M164351 <HTML><HEAD></HEAD><BODY><P>How do I calculate the number of days from today since a date in the format of <SPAN style="text-decoration: underline;"><STRONG>2/3/2012 1:55PM</STRONG></SPAN>?</P><P></P><P>And how do I calculate the number of days between two dates in these two different formats - format 1 <SPAN style="text-decoration: underline;"><STRONG>2/3/2012 1:55PM</STRONG></SPAN> and format 2 <STRONG style="text-decoration: underline;">12/12/2012 </STRONG>?</P></BODY></HTML> Thu, 14 Mar 2013 10:55:16 GMT https://community.qlik.com/t5/QlikView/Date-Calculations/m-p/440911#M164351 2013-03-14T10:55:16Z Re: Date Calculations https://community.qlik.com/t5/QlikView/Date-Calculations/m-p/440912#M164352 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>No of days Bet two dates using Interval function is:</P><P></P><P>Interval ( Date(Date1)- Date(Date2) , 'D') </P><P></P><P>Regards,</P><P>Nirav Bhimani</P></BODY></HTML> Thu, 14 Mar 2013 11:03:35 GMT https://community.qlik.com/t5/QlikView/Date-Calculations/m-p/440912#M164352 nirav_bhimani 2013-03-14T11:03:35Z