topic Re: Date comparison (without time&hour) in QlikView https://community.qlik.com/t5/QlikView/Date-comparison-without-time-hour/m-p/1413296#M427194 <HTML><HEAD></HEAD><BODY><P>Dayname(Date1) = Dayname(Date2) is easiest. You could also use Floor(), or any number of other options. </P></BODY></HTML> Mon, 23 Oct 2017 13:44:58 GMT Or 2017-10-23T13:44:58Z Date comparison (without time&hour) https://community.qlik.com/t5/QlikView/Date-comparison-without-time-hour/m-p/1413295#M427193 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've stored two dates in my DB in the classic Date&amp;Time format and I'd like to compare them not considering the Time part, but only the day one&nbsp; (eg 23/10/17 13:30 should be compared with 23/10/17 13:31 and the result must be that they are equals).</P><P></P><P>Thank you for the help.</P><P></P><P>N.</P></BODY></HTML> Mon, 23 Oct 2017 13:42:49 GMT https://community.qlik.com/t5/QlikView/Date-comparison-without-time-hour/m-p/1413295#M427193 Anonymous 2017-10-23T13:42:49Z Re: Date comparison (without time&hour) https://community.qlik.com/t5/QlikView/Date-comparison-without-time-hour/m-p/1413296#M427194 <HTML><HEAD></HEAD><BODY><P>Dayname(Date1) = Dayname(Date2) is easiest. You could also use Floor(), or any number of other options. </P></BODY></HTML> Mon, 23 Oct 2017 13:44:58 GMT https://community.qlik.com/t5/QlikView/Date-comparison-without-time-hour/m-p/1413296#M427194 Or 2017-10-23T13:44:58Z Re: Date comparison (without time&hour) https://community.qlik.com/t5/QlikView/Date-comparison-without-time-hour/m-p/1413297#M427195 <HTML><HEAD></HEAD><BODY><P>Thank you Shoham for the prompt reply and for the aswer!</P><P></P><P>I've lost a lot of time looking for it!</P><P></P><P>N.</P></BODY></HTML> Mon, 23 Oct 2017 13:56:07 GMT https://community.qlik.com/t5/QlikView/Date-comparison-without-time-hour/m-p/1413297#M427195 Anonymous 2017-10-23T13:56:07Z