topic problem calculating difference between 2 dates in QlikView https://community.qlik.com/t5/QlikView/problem-calculating-difference-between-2-dates/m-p/245451#M1182544 <HTML><HEAD></HEAD><BODY><P>Could you give an example of raw data field values, your Script expression and your expected outcome ?</P></BODY></HTML> Mon, 02 Jan 2012 17:57:50 GMT swuehl 2012-01-02T17:57:50Z problem calculating difference between 2 dates https://community.qlik.com/t5/QlikView/problem-calculating-difference-between-2-dates/m-p/245450#M1182543 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying out Qlikview. I have made a connection to different sql tables and now I am trying to calculate the payment terms on invoices by substracting two dates from each other and saving them as a new field. Calculation works fine, but ... is always wrong by 2 days. When payment term is 14 days, is calculates 16 days. What is going wrong ? Any ideas ?</P><P></P><P>TXS</P></BODY></HTML> Mon, 02 Jan 2012 14:33:49 GMT https://community.qlik.com/t5/QlikView/problem-calculating-difference-between-2-dates/m-p/245450#M1182543 2012-01-02T14:33:49Z problem calculating difference between 2 dates https://community.qlik.com/t5/QlikView/problem-calculating-difference-between-2-dates/m-p/245451#M1182544 <HTML><HEAD></HEAD><BODY><P>Could you give an example of raw data field values, your Script expression and your expected outcome ?</P></BODY></HTML> Mon, 02 Jan 2012 17:57:50 GMT https://community.qlik.com/t5/QlikView/problem-calculating-difference-between-2-dates/m-p/245451#M1182544 swuehl 2012-01-02T17:57:50Z