Code to pull records with dates between...
$30-100 USD
货到付款
I need the sql statement to place in the following code to pull all records where DoS (Date of Service)is between DatePicker1 and DatePicker2. In other words, I want to pull all dates between datepicker1 THROUGH DatePicker2 using the DoS field in my Table, "TableService". The database is Access2000 (I don't need any of the connecting code, I've got all that. Just the SQL statement that will grab all records with dates falling between the datepickers. The datepickers are long format in VB6. The DoS field have dates saved also in long format (e.g., 07/08/2002 11:32:55 AM). Private Sub PullDates() Dim cnn1 As [login to view URL] Dim strQry As String Dim rsDoS As [login to view URL] strQry = "SELECT * from TableService WHERE DoS '...this is the code I'm looking for... Set cnn1 = New [login to view URL] [login to view URL] = g_ADOconnectionstring [login to view URL] Set rsDoS = GetRecordSet(cnn1, strQry) 'Here I do some stuff with the returned rsDoS Set cnn1 = Nothing Set rsDoS = Nothing End Sub Also, my DatePickers are in long date format and I have maybe 10 to 20 records I want pulled I realize this is pretty simple, I just cant figure it out!
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
## Platform
windows
## Deadline information
Cheap and quick will get my bid (e.g., less than 5 or 10 dollars). Thanks!
项目ID： #2860530
关于项目
授予：
有109名威客正在参与此工作的竞标，均价$14/小时
