ACCESS SELECT唔到特定日期

http://home.netvigator.com/~fhappy/my.7z

這個accdb, 用vb select

sqlstr = "SELECT * FROM Booking;"
這句沒有問題, select出來用debugger看datatable
日期是 dd/mm/yyyy 0:00:00

但我用以下三種方法, 都select唔到任何record, 請問應該怎select呢?

sqlstr = "SELECT * FROM Booking where BookingDate between #1/5/2009 0:00:00# and #1/5/2010 0:00:00#"

sqlstr = "SELECT * FROM Booking where BookingDate between #1/5/2009# and #1/5/2010#"

sqlstr = "SELECT * FROM Booking where BookingDate between #" & A_DateTimePicker.Text & "# and #" & B_DateTimePicker.Text & "#;"

但係有time condition...., focus on date only first

TOP

唔明

我在access中看沒有時間跟尾
亦都在該field中的format set了 dd/mm/yyyy
但都沒有作用

TOP

試下用dateserial

TOP

date time format錯左??
dd/MM/yyyy
not dd/mm/yyyy

TOP

定係要用{2010/5/6}?

TOP

用呢個:
between cdate('1/5/2009 0:00:00') and cdate('1/5/2010 0:00:00')

TOP

用呢個:
between cdate('1/5/2009 0:00:00') and cdate('1/5/2010 0:00:00')

TOP