topic Comparing two dates to eachother in QlikView https://community.qlik.com/t5/QlikView/Comparing-two-dates-to-eachother/m-p/252731#M1206633 <HTML><HEAD></HEAD><BODY><P>Hello I want to see the difference in days between two dates. They are formated as ex 2008-03-18 00:00:00 and I have set the the numberformating to YYYY-MM-DD hh:mm:ss, when I use teh expression first.date-second.date it is not working. What to do?</P><P>/J</P></BODY></HTML> Wed, 21 Apr 2010 10:26:49 GMT 2010-04-21T10:26:49Z Comparing two dates to eachother https://community.qlik.com/t5/QlikView/Comparing-two-dates-to-eachother/m-p/252731#M1206633 <HTML><HEAD></HEAD><BODY><P>Hello I want to see the difference in days between two dates. They are formated as ex 2008-03-18 00:00:00 and I have set the the numberformating to YYYY-MM-DD hh:mm:ss, when I use teh expression first.date-second.date it is not working. What to do?</P><P>/J</P></BODY></HTML> Wed, 21 Apr 2010 10:26:49 GMT https://community.qlik.com/t5/QlikView/Comparing-two-dates-to-eachother/m-p/252731#M1206633 2010-04-21T10:26:49Z Comparing two dates to eachother https://community.qlik.com/t5/QlikView/Comparing-two-dates-to-eachother/m-p/252732#M1206634 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>please see the attached example.</P><P>Are you sure that your dates are interpreted as numbers and not as characters?</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Wed, 21 Apr 2010 10:32:14 GMT https://community.qlik.com/t5/QlikView/Comparing-two-dates-to-eachother/m-p/252732#M1206634 2010-04-21T10:32:14Z Comparing two dates to eachother https://community.qlik.com/t5/QlikView/Comparing-two-dates-to-eachother/m-p/252733#M1206635 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I have got the comparison to work but I am having troubles with counting the numer of items orders that have a difference in time.</P><P></P><P>count(if(date#([Leveransprecision.Bokat datum]-[Leveransprecision.Lovat leveransdatum],'DD')&lt;&gt;0), Leveransprec_KEY)</P><P>Something is wrong but I don't know what. And instead of Leveransprec_KEY I could use just "1" cause I want to increase the number by one when there is a difference</P><P>Thanks in advance</P><P>/J</P><BR /><BR /></BODY></HTML> Wed, 21 Apr 2010 12:52:20 GMT https://community.qlik.com/t5/QlikView/Comparing-two-dates-to-eachother/m-p/252733#M1206635 2010-04-21T12:52:20Z Comparing two dates to eachother https://community.qlik.com/t5/QlikView/Comparing-two-dates-to-eachother/m-p/252734#M1206636 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>please upload a short example (*.qvw).</P><P>Than it´s much more easier to find a solution.</P><P>Thank you!</P><P>Rainer</P></BODY></HTML> Wed, 21 Apr 2010 13:07:20 GMT https://community.qlik.com/t5/QlikView/Comparing-two-dates-to-eachother/m-p/252734#M1206636 2010-04-21T13:07:20Z