How to query date type data?

Please tell me, how to query in ACCESS database and SQL SERVER database?

We can achieve this in the following ways:

1. In the ACCESS database:

SELECT * FROM yourTable where dateField=#2001/4/15#

(Note: The date must be added with a # sign).

2. In the SQL SERVER database:

SELECT * FROM yourTable where dataField=' april 15,2001'

(Note: Dates are used as strings).

Of course, if the date format uses a format such as yy/mm/dd or yyyy/mm/dd, it depends on the server settings.