MS Access
In SELECT queries for Access (JET), put hash signs around the date. No quote marks.
SELECT *
FROM tblInvoices
WHERE CustomerID = 1 AND InvoiceDate > #01/01/98#
From: http://msdn.microsoft.com/en-us/library/aa140011(office.10).aspx
SQL Server
WHERE (Members.DateAdded < CONVERT(DATETIME, '2010-06-08 00:00:00', 102)) AND (Contacts.PhoneExt <> '11')
SELECT CONVERT(date, getdate()) - get date from a datetime field.
WHERE CONVERT(date, DateAdded) = '2019-01-21'
Tags: date, format, hash, pound, syntax, sql, msaccess, query