# VB and Access small problem!

Posted by Ton on October 28, 1999 at 11:04:50:

In VB,
If I want to select a record by the criteria "Date", What is the syntax?
e.g.
Data.Recordset.OpenRecrodSet("Select * from [Table] [A] where [A].[GetDate] = Date")
I always get Error if that part, what can I do?? ^^^^^^^
Thank You
PS. My database is Access and GetDate's datatype is Date (short format)

Follow Ups:

- Re: VB and Access small problem! ´óºº±¤ 18:39:46 10/28/99 (0)