If your DBMS is SQL Server then try
GETDATE()
instead of
DATE()
, because there is no such function. GETDATE() is used to get the current date of the DB server.
OleDbCommand cmdmnt = new OleDbCommand("select * from patient_info where DATEDIFF(m, E_date, GETDATE())=0",cn);
Hope, it helps :)
Please let me know if I am missing something here.