DataTable.select(Date=?)

[Jim Schneider]

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.

 

[Cor]

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