I am writing a query in MS-Access using a SQL linked data table. The field, ServiceDateTime is a Date/Time format. When I look at the data it comes across as 9/20/13 8:52:00 AM.
When I enter the criteria =#9/20/13# I get no data returned.
How can transform the data to allow date criteria?