topic Help with a set that compare dates in QlikView https://community.qlik.com/t5/QlikView/Help-with-a-set-that-compare-dates/m-p/459813#M1154893 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>How should I wright a set expression that shows the PersID for the following?</P><P></P><P>StartDate should be larger then EndDate but not larger then EndDate12</P><P></P><P>(EndDate12 = EndDate + 12 months. I create this in the script using addmonths)</P></BODY></HTML> Tue, 16 Apr 2013 17:51:33 GMT 2013-04-16T17:51:33Z Help with a set that compare dates https://community.qlik.com/t5/QlikView/Help-with-a-set-that-compare-dates/m-p/459813#M1154893 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>How should I wright a set expression that shows the PersID for the following?</P><P></P><P>StartDate should be larger then EndDate but not larger then EndDate12</P><P></P><P>(EndDate12 = EndDate + 12 months. I create this in the script using addmonths)</P></BODY></HTML> Tue, 16 Apr 2013 17:51:33 GMT https://community.qlik.com/t5/QlikView/Help-with-a-set-that-compare-dates/m-p/459813#M1154893 2013-04-16T17:51:33Z Re: Help with a set that compare dates https://community.qlik.com/t5/QlikView/Help-with-a-set-that-compare-dates/m-p/459814#M1154894 <HTML><HEAD></HEAD><BODY><P>I think I got one solution.</P><P id="divSAPreview">Count({$&lt;StartDate={"&gt;$(=Date(EndDate))&lt;$(=Date(EndDate12))"}&gt;}PERSID)</P></BODY></HTML> Tue, 16 Apr 2013 19:22:50 GMT https://community.qlik.com/t5/QlikView/Help-with-a-set-that-compare-dates/m-p/459814#M1154894 2013-04-16T19:22:50Z