关于日期类型问题!
比如我的ACCESS有一个日期类型的字段,如;
2007-08-12 16:20:00
我想分别取出日期部门和时间部分,谢谢!
[解决办法]
Dim d As String, a() As String
d = "2007-08-12 16:20:00 "
a = Split(d, Space(1))
DIM SQL AS STRING
Debug.Print a(0)
Debug.Print a(1)
SQL= "select * from 表 where 日期字段=# " & a(0) & "# and 日期字段=# " & a(1) & "# "
