I normally provide the month instead of the date for that kind of operation by using Format([datefield],"MM") or the datepart function.