Where the field dob specified in the conditions? Now if join_date was in side month(join_date) In Then that would be a correct ans.