在vb裏用SQL get date problem(編號：2263)

for example
data1.recordsource = "select XX from XX where date ＞= #date$()#"
why always can't compile?
error message: date return error something like that...
請指點! 多謝!