https://community.qlik.com/t5/QlikView/Re-Calculating-number-of-days-between-two-date-fields/m-p/1988920#M1221248 <P>Hi Sir, i am very new to Qlik and hope you could help resolve this issue similar to calculate different in days: I would like to know from Invoice Date to Receiving Order Date, how long it took to produce a product. the calculation works well if the invoice date is later than order date. However, the result would goes into negative when the receiving order date is greater than invoice date. example: received order on 25th of the month and invoiced on the 1st of next month. hence the result is -24 instead of 5 or 6 days depending on if that month has 30 or 31 (or 28) days in the calendar.</P> <P>Seeking your expert solution on this issue, thanks for your reading.</P> Wed, 05 Oct 2022 04:25:03 GMT VNPython 2022-10-05T04:25:03Z https://community.qlik.com/t5/QlikView/Re-Calculating-number-of-days-between-two-date-fields/m-p/1988920#M1221248 <P>Hi Sir, i am very new to Qlik and hope you could help resolve this issue similar to calculate different in days: I would like to know from Invoice Date to Receiving Order Date, how long it took to produce a product. the calculation works well if the invoice date is later than order date. However, the result would goes into negative when the receiving order date is greater than invoice date. example: received order on 25th of the month and invoiced on the 1st of next month. hence the result is -24 instead of 5 or 6 days depending on if that month has 30 or 31 (or 28) days in the calendar.</P> <P>Seeking your expert solution on this issue, thanks for your reading.</P> Wed, 05 Oct 2022 04:25:03 GMT https://community.qlik.com/t5/QlikView/Re-Calculating-number-of-days-between-two-date-fields/m-p/1988920#M1221248 VNPython 2022-10-05T04:25:03Z https://community.qlik.com/t5/QlikView/Re-Calculating-number-of-days-between-two-date-fields/m-p/1989025#M1221249 <P>You need to calculate the differences with the dates and not the day's of these dates, like:</P> <P>Date1 - Date2 as Diff</P> <P>- Marcus</P> Wed, 05 Oct 2022 09:25:39 GMT https://community.qlik.com/t5/QlikView/Re-Calculating-number-of-days-between-two-date-fields/m-p/1989025#M1221249 marcus_sommer 2022-10-05T09:25:39Z https://community.qlik.com/t5/QlikView/Re-Calculating-number-of-days-between-two-date-fields/m-p/1991016#M1221264 <P>thanks Marcus, i will try and revert back if any issue.</P> Mon, 10 Oct 2022 23:52:53 GMT https://community.qlik.com/t5/QlikView/Re-Calculating-number-of-days-between-two-date-fields/m-p/1991016#M1221264 VNPython 2022-10-10T23:52:53Z