using between for date range

**ChipJohns** · 10:21 AM

Ok,
I've racked my brain. Tried to figure this out.. Help...!

Trying to figure out how to retrieve info within a date range. Here is what I'm doing

Code:

Dim dDateFrom
dDateFrom=FormatDateTime(1/1/2008,2) 
Dim dDateTo
dDateTo=FormatDateTime(1/20/2008,2)
 
strQ1 = "SELECT *"
strQ1 = strQ1 & " FROM smeTracking"
strQ1 = strQ1 & " WHERE smTrDate BETWEEN " & dDateFrom & " AND " & dDateTo
strQ1 = strQ1 & " ORDER BY smTrDate"
strQ1 = strQ1 & ";"
objRS1.Open strQ1

No Errors. Just no results...

What's interesting is that when I change to NOT BETWEEN... All the records show.!?

What am I missing here!?

Thanks for any assistance.

CHip

**ChipJohns** · 03-20-2008, 12:30 PM

And it works!

Code:

Dim dDateFrom
dDateFrom=#01/21/2008# 
Dim dDateTo
dDateTo=#01/25/2008#
strQ1 = "SELECT *"
strQ1 = strQ1 & " FROM smeTracking"
strQ1 = strQ1 & " WHERE smTrDate>=#" &  dDateFrom
strQ1 = strQ1 & "#" & " AND smTrDate<=#" & dDateTo
strQ1 = strQ1 & "# ORDER BY smTrDate"
strQ1 = strQ1 & ";"
objRS1.Open strQ1

**ForrestCroce** · 03-21-2008, 02:28 AM

Microsoft Access?

**ChipJohns** · 03-21-2008, 08:51 AM

YES!

How did you know

**chrishirst** · 03-21-2008, 12:24 PM

He's a mind reader

**Learning Newbie** · 03-21-2008, 02:58 PM

Frosty is always reading my mind. I wish he'd stop. I think he got my ATM PIN number.