https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/107845.aspxThu, 01 Sep 2016 18:38:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:107845jpl18lal220https://www.infopathdev.com:443/forums/thread/107845.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=107845<p>I am trying to count the number of records that have a Start and End Date that fall within today. I realized an issue where if the Start Date is the same as the today value, it won&#39;t count the record. The Start and End Date are coming from a data connection to a SharePoint list, so I believe it has something to do with the formatting of the dates.</p><p>count(ID[StartDate &lt;= today() and EndDate &gt;= today()])&nbsp; <br /></p><p>Example Data. (Count should be 3, but when I do it, I get 1 because it isn&#39;t counting Records 1 and 3)<br /></p><p>Today&#39;s Date: 2016-09-01<br /></p><p>ID &nbsp; &nbsp; &nbsp; StartDate &nbsp; &nbsp;&nbsp; EndDate</p><p>1 &nbsp; &nbsp; &nbsp;&nbsp; 9/1/2016&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; 9/4/2016</p><p>2 &nbsp; &nbsp; &nbsp;&nbsp; 8/29/2016&nbsp;&nbsp; &nbsp; &nbsp; 9/7/2016</p><p>3 &nbsp; &nbsp; &nbsp;&nbsp; 9/1/2016 &nbsp; &nbsp; &nbsp; &nbsp; 9/1/2016 </p><p>I even tried to simplify it so that I was just trying to get the count of Start Date that equal Today&#39;s date, but this returns 0.<br /></p>count(ID[StartDate = today()]) <p>Is there a way to format the dates the same, so my numbers are accurate?<br /></p>