Avatar of arcross
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Datatable filter by date

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?
ASP.NETVisual Basic.NET

Avatar of undefined
Last Comment

8/22/2022 - Mon