<div>
<br />
change<br />
&nbsp; &nbsp; dt.Compute(&quot;COUNT(itemid)&quot;<wbr />,&quot;DatePost<wbr />ed=# &quot;&nbsp;&amp; date.today &amp;&nbsp;&quot;#&quot;<br />
to <br />
&nbsp; &nbsp; dt.Compute(&quot;COUNT(itemid)&quot;<wbr />,Int(DateP<wbr />osted) &amp;&nbsp;*= &quot;&nbsp;&amp; date.today)
</div>


<div>
or<br />
&nbsp; &nbsp; dt.Compute(&quot;COUNT(itemid)&quot;<wbr />,Int(DateP<wbr />osted) &amp;&nbsp;*= &quot;&nbsp;&amp; INT(date.today))
</div>


<div>
Have you tried using date.Today.ToShortDateStri<wbr />ng instead of date.today?<br />

</div>


<div>
Reecio i tried your suggestion<br />
<br />
Dim Exp As Integer = CInt(dt.Compute(&quot;COUNT(ite<wbr />mid)&quot;, &quot;dateposted = # &quot;&nbsp;&amp; Date.Today.ToShortDateStri<wbr />ng &amp;&nbsp;&quot;#&quot;))<br />
<br />
And i got an error: &quot;String was not recognized as a valid DateTime&quot;
</div>


<div>
Check your settings. I have a feeling you're system is English date format and the table is in American.<br />
Therefore it will have a fit when you try to use &quot;17/07/2008&quot; as it doesnt see 17 as a valid month.
</div>


<div>
checking in the sql express 2005, the date are stored in english uk. My pc has english settings too. 
</div>


<div>
im linking it Reecio. I got it working doing the date &gt;= than todays date. Using the same sintax and works fine. Weird!<br />
<br />
thanks!
</div>


<div>
<div class="content wysiwyg-content">
Ive got a datatable and im doing a compute to get the records that have been posted today.<br />
<br />
dt.Compute(&quot;COUNT(itemid)&quot;<wbr />,&quot;DatePost<wbr />ed=# &quot;&nbsp;&amp; date.today &amp;&nbsp;&quot;#&quot;<br />
<br />
The date is saved in the database with this format : dd/MM/yyyy HH:mm:ss<br />
But i only want to filter the day,month and year. Not the hours. But i cant make it to work.<br />
<br />
any ideas?
</div>
</div>


Ive got a datatable and im doing a compute to get the records that have been posted today.

dt.Compute("COUNT(itemid)","DatePosted=# " & date.today & "#"

The date is saved in the database with this format : dd/MM/yyyy HH:mm:ss
But i only want to filter the day,month and year. Not the hours. But i cant make it to work.

any ideas?

Datatable filter by date

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,