In order to test for a date value with Access tables, surround the date with single apostrophes. Surround the date with pound symbols for SQL Server data.

Name: In order to test for a date value with Access tables, surround the date with single apostrophes. Surround the date with pound symbols for SQL Server data.
Brand: Quizplus
Rating: 4.8 (35 reviews)

Question

Quizplus · Accepted Answer

In Access tables, dates are surrounded by pound symbols (#), while in SQL Server, dates are typically surrounded by single apostrophes (').

In Order to Test for a Date Value with Access