select * from table where datefield between '2003-/01/01' and '2003/01/31'
strSQL="select * from table where timefield bwtween '" & varT1 & "' and '" & varT2 & "'"
'数据库为ACCESS: strsql="select * from tablename where 日期字段 between # 2003-10-1 # and # 2003-10-15 # " '数据库为SQL: strsql="select * from tablename where 日期字段 between '2003-10-1' and '2003-10-15' "
strsql="select * from tablename where 日期字段 between # 2003-10-1 # and # 2003-10-15 # "
'数据库为SQL:
strsql="select * from tablename where 日期字段 between '2003-10-1' and '2003-10-15' "