SELECT * FROM tblattendancelog WHERE MONTH(dutydatetime) BETWEEN '01' and '01' AND YEAR(dutydatetime) BETWEEN 2009 and 2020
i Will Select " Month " and Year Get Data