What is a good way to compare the month portion of a date when using an SQL query?
Posted on 2006-07-11
I have a database with a field containing dates in the format yyyy/mm/dd. I get the beginning and ending months from the user with 2 combo boxes. So let's say the user wants only the samples between SEP and OCT. What is the correct SQL syntax to get this? I'm looking for the '....' part of the Select statement below. I am using Access and VB.Net 1.1
Thank you in advance.
cboFMonth.Text = "SEP"
cboLMonth.Text = "NOV"
Dim strSQL as String = "SELECT DateReceived WHERE DateReceived...."