DataTable.select(Date=?)

's Computer Specifications

I have a SQL Server Field named DateofVisit, datatype of DateTime and a
Variable named gblDOV datatype of DateTime. I can confirm via the immediate
window that the values in both variables appear equal but yet I cannot seem
to return any rows with the following.

ARow=DSSA.Tables("Answers").Select("DateofVisit='" & gblDOV & "'")

What is the proper way to accomplish this simple task.

Thanks for your help.

's Computer Specifications

Hi Jeremy
Out of topic, but my compliments with the way you did this answer
Cor

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DataTable.Select vs DataTable.rows.Find vs foreach	Dave	Microsoft C# .NET	1	17th May 2007 09:06 PM
Retrieving datarows using DataTable.Select method and adding it to new DataTable	C.Anand via DotNetMonster.com	Microsoft ADO .NET	4	4th Apr 2005 05:21 PM
How can I use real SQL on a DataTable? i.e. not array of rows using a filter... as in DataTable.Select	Dan V.	Microsoft C# .NET	3	1st Jul 2004 03:06 PM
DataTable.Select returns no rows on a date filter	=?Utf-8?B?U2lvYmhhbg==?=	Microsoft ADO .NET	1	1st Jun 2004 10:34 AM
truncate time from date in DataTable.Select()	Eddie	Microsoft ASP .NET	1	23rd Dec 2003 10:55 PM