SQL IN VB - Using the Between clause 1

[aviles22]

I want to search the DB for records that fall between two dates using two variables in my SQL Statement.

Dim Date1 as Date
Dim Date2 as Date

("Select * from ActiveJobs where JobDate between (*****
**this is where I need help using the variables above)


[sig][/sig]

 

[dpaulson]

Try something like this
Dim Date1 as Date
Dim Date2 as Date

"Select * from ActiveJobs where JobDate between #" & date1 & "# and #" & date2 & "#"


[sig]<p>David Paulson<br><a href=mailto: > </a><br><a href= > </a><br> [/sig]