title: Getting the first and last dates in a month
body: <p>I have two comboboxes that lets the user select a date and year.  What I want to do is to translate this into my query in access, which requires a [start date] and an [end date] parameter.</p>
  
  <p>I.E. user picks "May" and "2013" in the combo boxes</p>
  
  <p>My query is setup between [start date] and [end date], so I want to translate this month and year selection from the combo boxes into two strings (startdate and enddate, then pass them as command parameters) that contain MM/DD/YYYY, MM/DD/YYYY.  What is the best way to take two strings and get the first valid day and last valid day.  I have:</p>
  
  <pre><code>FirstDayInMonth = DateSerial( _
   Year(Date), Month(Date), 1)
  
  LastDayInMonth = DateSerial( _
   Year(dtmDate), Month(dtmDate) + 1, 0)
  </code></pre>
  
  <p>But I need to make the switch from a string into a date format to get back the first/last day of the selected month, using only the month ("MAY") and year ("2013")?  Am I missing something relatively simple?</p>