get records between start day of a month and end day of the month

hi friends,i need a database query to retrieve records between the start day of a month and the end day of a month...i have two fields in my table(status,date)...can you people tell me how can i accomplish what i required???