Using Month and year only to get all data

[Shuja Ali]

What database are you using?

If it is SQL Server then look at DatePart function. This function will let you divide the date into Month, Day and Year.