Date-related issues encountered in Access data queries

Today, when you make an Access database query, there is a date comparison problem, and when you do not join "# #" when writing less than a certain date will get the record, and write greater than a record is not.

  SELECT * FROM table WHERE Date < 2007-1-1

Retrieves the data for all dates in the table on January 1, 2007 and November 1, 2007, and the date type in Access must be #, and the words will be treated as strings, without the desired effect.
Where the Date field is the date/time type.