请帮忙。谢~ datetime相关

Question

Sql1 = "select * from table where left(prj_btime,4)'"+(nowyear-1)+"'"

Answer 1

试试
Dim time As DateTime
time = time.AddYears(Now.Year - time.Year) '得到今年年初的时间
"select * from table where prj_btime<" & time.ToOADate & " AND prj_btime>" & time.AddYears(-1).ToOADate

Answer 2

问题已解决。select * from table where year(prj_btime)=time.AddYears(-1).ToOADate
谢谢。