How to query data with date in mssql

It come from simple question. what is the syntax for query data with date/time filter in ms access?.

Here we will show you how to do that. It simply using query like example below :

SELECT SNo
FROM Staff
WHERE Format([ComplaintDate],"yyyy-mm-dd")>='2014-08-10'