select * from table where datediff(m,signdate ,now())=0
Sql="Select * From BIAO Where Year(Signdate)="&Year(Date())&" And Month(Signdate)="&Month(Date)
select * from table where datediff('m',signdate ,now())=0
