java按时间范围过滤_按日期过滤数据集（月/年）

我有一个绑定到Access DB的DataGridView . DB上的一个字段是日期(日)格式 . 我希望DataGridView只显示DateTimerPicker中显示的月/年内的行 . 这是我正在使用的代码：

Private Sub FrmRelatorio_Load(sender as Object，e As EventArgs)处理MyBase.Load

'TODO: This line of code loads data into the 'S_CampoDataSet.Servico' table. You can move, or remove it, as needed.

Me.ServicoTableAdapter.Fill(Me.S_CampoDataSet.Servico)

'Get current month

Dim currentDate As DateTime = DateTime.Now

Dim mesactual = currentDate.Month

'Get DateTimePicker Month

Dim dataescolhida As DateTime = DateTimePicker1.Value

Dim mesescolhido = dataescolhida.Month

ServicoBindingSource.Filter = "Util1 = '" & Numero_Utilizador & " ' "

'ServicoBindingSource.Filter = "Dia = '" & mesescolhido & " ' "

ServicoBindingSource.Sort = "Dia ASC"

有人可以帮帮我吗？提前致谢 .