topic datediff issue in QlikView https://community.qlik.com/t5/QlikView/datediff-issue/m-p/218781#M71846 <HTML><HEAD></HEAD><BODY><P>i have two dates:</P><P>20090421 and 20090501 .. i need the datediff in days.</P><P>Date(LastPaymentDate,'YYYYMMDD') - Date(InvoiceDueDate,'YYYYMMDD') gives me 80</P></BODY></HTML> Thu, 21 Jan 2010 10:48:23 GMT amien 2010-01-21T10:48:23Z datediff issue https://community.qlik.com/t5/QlikView/datediff-issue/m-p/218781#M71846 <HTML><HEAD></HEAD><BODY><P>i have two dates:</P><P>20090421 and 20090501 .. i need the datediff in days.</P><P>Date(LastPaymentDate,'YYYYMMDD') - Date(InvoiceDueDate,'YYYYMMDD') gives me 80</P></BODY></HTML> Thu, 21 Jan 2010 10:48:23 GMT https://community.qlik.com/t5/QlikView/datediff-issue/m-p/218781#M71846 amien 2010-01-21T10:48:23Z datediff issue https://community.qlik.com/t5/QlikView/datediff-issue/m-p/218782#M71847 <HTML><HEAD></HEAD><BODY><P>nevermind</P><P></P><P>date#(LastPaymentDate,'YYYYMMDD') - date#(InvoiceDueDate,'YYYYMMDD') as Due</P><P></P></BODY></HTML> Thu, 21 Jan 2010 10:58:41 GMT https://community.qlik.com/t5/QlikView/datediff-issue/m-p/218782#M71847 amien 2010-01-21T10:58:41Z datediff issue https://community.qlik.com/t5/QlikView/datediff-issue/m-p/218783#M71848 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Use Date# instead of the Date-function.<BR />The Date-function only formats the field as a date. Date# evaluates the field as a date with numeric representation and the result will be 10.</P><P>/Fredrik</P></BODY></HTML> Thu, 21 Jan 2010 11:04:29 GMT https://community.qlik.com/t5/QlikView/datediff-issue/m-p/218783#M71848 2010-01-21T11:04:29Z