topic Date comparison confusion (Weekend) in QlikView https://community.qlik.com/t5/QlikView/Date-comparison-confusion-Weekend/m-p/910483#M316179 <HTML><HEAD></HEAD><BODY><P>Hi Community!</P><P></P><P>I am confused by dates again!</P><P></P><P>can anyone tell me why this is so:</P><P></P><P><IMG __jive_id="94986" alt="DateConfusion1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94986_DateConfusion1.png" style="height: auto;" /></P><P><IMG __jive_id="94987" alt="DateConfusion2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/94987_DateConfusion2.png" style="height: auto;" /></P><P>As you can see I am comparing the minimum of the date field (27 july 2015) with a date calculation which gives a date that is the same.&nbsp; But the if statement says they are not equal!</P><P></P><P>Please help.&nbsp; Am I just going mad?</P><P></P><P></P><P>I've just worked it out!</P><P></P><P>Weekend returns a time element.&nbsp; weekend is the last millisecond of the week.&nbsp; So I needed a floor function to get just the date and ignore the time!</P><P></P><P>if(Min(Date)=floor(Weekend(today))-13</P></BODY></HTML> Wed, 05 Aug 2015 01:01:20 GMT shanemichelon 2015-08-05T01:01:20Z Date comparison confusion (Weekend) https://community.qlik.com/t5/QlikView/Date-comparison-confusion-Weekend/m-p/910483#M316179 <HTML><HEAD></HEAD><BODY><P>Hi Community!</P><P></P><P>I am confused by dates again!</P><P></P><P>can anyone tell me why this is so:</P><P></P><P><IMG __jive_id="94986" alt="DateConfusion1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94986_DateConfusion1.png" style="height: auto;" /></P><P><IMG __jive_id="94987" alt="DateConfusion2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/94987_DateConfusion2.png" style="height: auto;" /></P><P>As you can see I am comparing the minimum of the date field (27 july 2015) with a date calculation which gives a date that is the same.&nbsp; But the if statement says they are not equal!</P><P></P><P>Please help.&nbsp; Am I just going mad?</P><P></P><P></P><P>I've just worked it out!</P><P></P><P>Weekend returns a time element.&nbsp; weekend is the last millisecond of the week.&nbsp; So I needed a floor function to get just the date and ignore the time!</P><P></P><P>if(Min(Date)=floor(Weekend(today))-13</P></BODY></HTML> Wed, 05 Aug 2015 01:01:20 GMT https://community.qlik.com/t5/QlikView/Date-comparison-confusion-Weekend/m-p/910483#M316179 shanemichelon 2015-08-05T01:01:20Z