我把格式改成如下：
date1 = CDate(#4/1/2007#)

date2 = CDate(#4/5/2007#)

serstr = "select * from test where Date between '"&date1&"' And '"&Date&"'"
或
serstr = "select * from test where Date between #04012007# And #04052007#"
或
serstr = "select * from test where Date between #4/1/2007# And #4/5/2007#"
都没用，请教大家还应该怎么改阿？？