Which of the following query criteria would be used to produce results for Date/Time fields containing a date of December 12,2014?
A) 12/12/2010
B) #12/12/2010#
C) Between #12/11/2010# and #12/14/2010#
D) 12/11/2010

Question

Quizplus · Accepted Answer

For Date/Time fields, the pound sign (#) is used to enclose the date value in the query criteria. Option B correctly uses the pound signs to specify the date of December 12, 2010.

Which of the Following Query Criteria Would Be Used to Produce