When Access executes a query, it throws a "data type mismatch in standard expression" error

In the project development process, it involves the operation of Access query,

However, if you write more T-SQL in MSSQL, Access will forget it.

In one query, it relates to the time field, which habitually writes:

SELECT COUNT (*) from [User] WHERE [createtime] > ' 2010-2-10 '

Of course, Access also habitual error: "The standard expression in the data type mismatch", just started to think their time value format passed wrong. But after debugging found no errors,

Then began to suspect access to SQL, a search for access Help, to write the following sentence is correct:

SELECT COUNT (*) from [User] WHERE [createtime] > #{0}#

Such a foolish mistake, hereby a note, to spur his carelessness.