i have a bit of a date issue.
using asp.net (vb) when i create a new record, i insert the date into the sql server database.
it is inserted in the datetime format (i.e. 5/2/2005 1:14:10 AM)
the issue is, when i do a seach for all records created on a specific date (for example, 5/2/2005), nothing is displayed because it, by default, is not just looking to match the date but also to match the exact time as well.
my question is, how do i do a seach for all records created on a specific date regardless of the time they were created (i.e. a search for 5/2/2005 will return all records created on that day).