Code to pull records with dates between...

Imekamilika Ilichapishwa Jul 14, 2002 Kulipwa wakati wa kujifungua

$30-100 USD

Kulipwa wakati wa kujifungua

Imekamilika Kulipwa wakati wa kujifungua

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!

Usimamizi wa Uhifadhi Data Uhandisi MySQL PHP Software Architecture Majaribio ya Software SQL Visual Basic

Kitambulisho cha Mradi: #2860530

Kuhusu mradi

109 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

Imetuzwa kwa:

Picha ya Profaili ya schneidervw
schneidervw

See private message.

$2 USD kwa siku 14
(Maoni 5)
4.2

109 wafanyakazi huru wanazabuni wastani wa $14 kwa kazi hii

Picha ya Profaili ya agiletechvw
agiletechvw

See private message.

$4.25 USD kwa siku 14
(Maoni 36)
6.5
Picha ya Profaili ya harisraheem
harisraheem

See private message.

$8.5 USD kwa siku 14
(Maoni 25)
6.4
Picha ya Profaili ya agrasth
agrasth

See private message.

$42.5 USD kwa siku 14
(Maoni 107)
6.2
Picha ya Profaili ya guruvenkat
guruvenkat

See private message.

$25.5 USD kwa siku 14
(Maoni 51)
5.8
Picha ya Profaili ya vstarvw
vstarvw

See private message.

$12.75 USD kwa siku 14
(Maoni 12)
5.8
Picha ya Profaili ya Quadville
Quadville

See private message.

$4.25 USD kwa siku 14
(Maoni 193)
5.5
Picha ya Profaili ya aarrsoftware
aarrsoftware

See private message.

$17 USD kwa siku 14
(Maoni 33)
5.6
Picha ya Profaili ya codetalkers
codetalkers

See private message.

$3.4 USD kwa siku 14
(Maoni 15)
5.1
Picha ya Profaili ya cskvw
cskvw

See private message.

$15.3 USD kwa siku 14
(Maoni 24)
5.2
Picha ya Profaili ya v5group
v5group

See private message.

$17 USD kwa siku 14
(Maoni 35)
5.4
Picha ya Profaili ya endrebx
endrebx

See private message.

$8.5 USD kwa siku 14
(Maoni 21)
4.8
Picha ya Profaili ya leepwo
leepwo

See private message.

$4.25 USD kwa siku 14
(Maoni 41)
4.7
Picha ya Profaili ya peterdimitrovvw
peterdimitrovvw

See private message.

$4.25 USD kwa siku 14
(Maoni 1)
4.4
Picha ya Profaili ya deanconsulting
deanconsulting

See private message.

$8.5 USD kwa siku 14
(Maoni 50)
4.6
Picha ya Profaili ya fusion35
fusion35

See private message.

$12.75 USD kwa siku 14
(Maoni 19)
4.4
Picha ya Profaili ya eeevren
eeevren

See private message.

$3.4 USD kwa siku 14
(Maoni 27)
4.4
Picha ya Profaili ya alwayscoffee
alwayscoffee

See private message.

$21.25 USD kwa siku 14
(Maoni 11)
4.4
Picha ya Profaili ya vw367803vw
vw367803vw

See private message.

$12.75 USD kwa siku 14
(Maoni 11)
4.9
Picha ya Profaili ya vw407490vw
vw407490vw

See private message.

$8.5 USD kwa siku 14
(Maoni 18)
4.0
Picha ya Profaili ya alokgarg
alokgarg

See private message.

$6.8 USD kwa siku 14
(Maoni 69)
4.2
Tuma Mradi Kama huu