小吳 VBQA 程式設計討論

VB6(Chinese), Access97, win95
請問怎樣才可在SQL中select乎合當日日期(now)的recordset?
Dim strSQL As String
Dim cookTime As Date
cookTime = FormatDateTime(Now, vbShortDate)
strSQL = " SELECT * FROM DISH WHERE cook_date Between " & cookTime & " "
Data2.RecordSource = strSQL
Data2.Refresh　＜---------" cook_date = 2000/4/20 AM 1:27:45
中語法錯誤(少了運算元)

請問怎樣才可在SQL中select乎合當日日期(now)的recordset?