topic Re: Finding number of hours between dates in QlikView https://community.qlik.com/t5/QlikView/Finding-number-of-hours-between-dates/m-p/888750#M531829 <HTML><HEAD></HEAD><BODY><P>you could also try this:</P><P></P><P>=interval(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">now()-'2015-05-17 23:59:02','hh')</SPAN></P></BODY></HTML> Tue, 19 May 2015 17:13:28 GMT 2015-05-19T17:13:28Z Finding number of hours between dates https://community.qlik.com/t5/QlikView/Finding-number-of-hours-between-dates/m-p/888748#M531827 <HTML><HEAD></HEAD><BODY><P>How do I find the number of hours from yesterday and now ?</P><P></P><P>Lets say hours between</P><P> 2015-05-17 23:59:02&nbsp;&nbsp;&nbsp; and now()</P><P></P><P></P><P>I must be able to validate this formula using a textbox</P></BODY></HTML> Tue, 19 May 2015 14:22:00 GMT https://community.qlik.com/t5/QlikView/Finding-number-of-hours-between-dates/m-p/888748#M531827 Anonymous 2015-05-19T14:22:00Z Re: Finding number of hours between dates https://community.qlik.com/t5/QlikView/Finding-number-of-hours-between-dates/m-p/888749#M531828 <HTML><HEAD></HEAD><BODY><P>=(now()-'2015-05-17 23:59:02')*24</P></BODY></HTML> Tue, 19 May 2015 15:29:06 GMT https://community.qlik.com/t5/QlikView/Finding-number-of-hours-between-dates/m-p/888749#M531828 robert_mika 2015-05-19T15:29:06Z Re: Finding number of hours between dates https://community.qlik.com/t5/QlikView/Finding-number-of-hours-between-dates/m-p/888750#M531829 <HTML><HEAD></HEAD><BODY><P>you could also try this:</P><P></P><P>=interval(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">now()-'2015-05-17 23:59:02','hh')</SPAN></P></BODY></HTML> Tue, 19 May 2015 17:13:28 GMT https://community.qlik.com/t5/QlikView/Finding-number-of-hours-between-dates/m-p/888750#M531829 2015-05-19T17:13:28Z