Month / Year base search use Sql query
SELECT * FROM TableName
WHERE MONTH(<dataFiled>) = 2 AND YEAR(<dataFiled>) = 2013
Ex
SELECT * FROM tblProcess
WHERE MONTH(UserProcessDate) = 2 AND YEAR(UserProcessDate) = 2013
SELECT * FROM TableName
WHERE MONTH(<dataFiled>) = 2 AND YEAR(<dataFiled>) = 2013
Ex
SELECT * FROM tblProcess
WHERE MONTH(UserProcessDate) = 2 AND YEAR(UserProcessDate) = 2013
No comments:
Post a Comment