SELECT statement for Access database using Date for WHERE Criteria - Support

SELECT statement for Access database using Date for WHERE Criteria

From Support

Jump to: navigation, search

Listed below is how to format a SELECT statement from an Access database and using a Date/Time field for the WHERE criteria.

C                   Eval      Rtn = SQL_RunSQLSel(SQL_Socket:              
C                             'SELECT * FROM NameAddress WHERE DATE1 = '+  
C                             '#12/25/2002#')
Personal tools