[VB] 看看怎么报语法错误呢？ 数据库, buyer, position, between, where

"select id,ticketdate,tickettime,ticketweight,buyer,buyerunit,freightname,freighttype,position,loadstate,conveyanceunit,ordernumber,icnumber from loadtrade where ticketdate between #2007-01-01#  and #2007-12-31# order by ticketdate,tickettime"

vb2005。xp下编程 数据库为sql ticketdate及tickettime为datetime型[hide][/hide]