Hello,
1. Try this Query if using SQL SERVER as Database,where TABLENAME is your table's name and ColumnName is your DateTime Column Name.
SELECT * FROM TABLENAME WHERE (Day(ColumnName)=DAY(GETDATE()) && MONTH(ColumnName) = MONTH(GETDATE()))
2. Try this Query if using MS ACCESS as Database,where TABLENAME is your table's name and ColumnName is your DateTime Column Name.
SELECT * FROM TABLENAME WHERE (Format(ColumnName, "d")=Format(Date(), "d") && Format(ColumnName, "m")=Format(Date(), "m"))
You will get results only of current date and month,than you process them as you want.