title: filter dataset column by date(Month/Year)
body: <p>I have a DataGridView bound to an Access DB.
  One of the fields on DB is Date(day) Format.
  I want the DataGridView displays only rows within the Month/Year displayd in a DateTimerPicker.
  This is the Code I'm using:</p>
  
  <p>Private Sub FrmRelatorio_Load(sender As Object, e As EventArgs) Handles MyBase.Load</p>
  
  <pre><code>    '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 = '" &amp; Numero_Utilizador &amp; " ' "
      'ServicoBindingSource.Filter = "Dia = '" &amp; mesescolhido &amp; " ' "
      ServicoBindingSource.Sort = "Dia ASC"
  </code></pre>
  
  <p>I can't find out how to deal with the column Dia, the one containing the Date(Day).
  This is what I want in run time:
  <a href="http://fpessoa.esferinfinita.com/StackOverflow/" rel="nofollow">http://fpessoa.esferinfinita.com/StackOverflow/</a></p>
  
  <p>Anyone could help me, please?
  Thanks in advance.</p>