https://community.qlik.com/t5/QlikView/Difference-in-Days-Date-Calculation/m-p/1938761#M1219256 <P>You may try it with:&nbsp;<SPAN>floor(ENTERED_DATE) - floor(ORDER_APPROVED_DATE)</SPAN></P> <P><SPAN>- Marcus</SPAN></P> Thu, 02 Jun 2022 06:29:31 GMT marcus_sommer 2022-06-02T06:29:31Z https://community.qlik.com/t5/QlikView/Difference-in-Days-Date-Calculation/m-p/1938705#M1219254 <P>Hi Gurus out there ,</P> <P>i am calculating the Aging (No of days) , where the calculation is - Entered Date - Approved Date (See atatched Excel Sheet). However , the calculation is bit out especially when it comes to, when the Entered Date and Approved Date is the same .&nbsp;</P> <P>Entered Date&nbsp; :&nbsp; timestamp(ENTERED_DATE,'DD-MMM-YY')</P> <P>Approved Date&nbsp; &nbsp;: timestamp(ORDER_APPROVED_DATE,'DD-MMM-YY')</P> <P>Aging : round(ENTERED_DATE-ORDER_APPROVED_DATE)</P> <P>p/s Column E is finding / expecatation from user</P> <P>&nbsp;</P> <P>How am i suppose to get the exact Aging (no. of days ) ?&nbsp;</P> <P>&nbsp;</P> Thu, 02 Jun 2022 03:25:01 GMT https://community.qlik.com/t5/QlikView/Difference-in-Days-Date-Calculation/m-p/1938705#M1219254 limfungkeat 2022-06-02T03:25:01Z https://community.qlik.com/t5/QlikView/Difference-in-Days-Date-Calculation/m-p/1938761#M1219256 <P>You may try it with:&nbsp;<SPAN>floor(ENTERED_DATE) - floor(ORDER_APPROVED_DATE)</SPAN></P> <P><SPAN>- Marcus</SPAN></P> Thu, 02 Jun 2022 06:29:31 GMT https://community.qlik.com/t5/QlikView/Difference-in-Days-Date-Calculation/m-p/1938761#M1219256 marcus_sommer 2022-06-02T06:29:31Z https://community.qlik.com/t5/QlikView/Difference-in-Days-Date-Calculation/m-p/1938772#M1219257 <P>Thanks Marcus ..is just that easy ? Ha ha ha ...</P> Thu, 02 Jun 2022 06:34:00 GMT https://community.qlik.com/t5/QlikView/Difference-in-Days-Date-Calculation/m-p/1938772#M1219257 limfungkeat 2022-06-02T06:34:00Z