ACCESS time query ...

coolhyde

CString strTime = "2002-2-1";
CString strSQL;
strSQL.Format("Select * From TableName where DateType = #%s#",strTime );

ozms123

Everyone upstairs meant to set the date field as text "????
But my ACCESS date field is set to "time/date" type! It is not a character type

thezee

The above methods are all possible
You can build a query in Access, switch to SQL view and try it with SQL statement
Select * From TableName where DateType = #2017-1-11#

qufeilong

The methods upstairs are all right. It may be that the date format you entered is different from the date format you access