Use the following format for a SELECT statement from a Microsoft Access database with a date or time field as the WHERE criterion:
 
C                   Eval      Rtn = SQL_RunSQLSel(SQL_Socket:              
C                             'SELECT * FROM NameAddress WHERE DATE1 = '+  
C                             '#12/25/2002#')          

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016