Still Having Date problems

[sinistapenguin]

I am still having problems retrieving records that are between 2 dates!

This is what I have done:
====================================================

SELECT *
FROM Invoices
WHERE InvoiceDate BETWEEN 'varStartDate' AND 'varEndDate'
ORDER BY InvoiceDate

VARIABLES:

varStartDate 1 Request.form("StartDate")
varEndDate 1 Request.form("EndDate")

====================================================

I have also tried:

SELECT *
FROM Invoices
WHERE InvoiceDate > 'varStartDate' AND InvoiceDate < 'varEndDate'
ORDER BY InvoiceDate

I cannot seem to get this to work properly. If anyone has any ideas, they would be gratefully received.

Thanks

Sinista

 

[Cheech]

SELECT *
FROM Invoices
WHERE InvoiceDate BETWEEN '#varStartDate#' AND '#varEndDate#'
ORDER BY InvoiceDate



Cheech


[Peace][Pipe]

 

[sinistapenguin]

Hi Cheech

Sorry, small syntax error in my original post.

The dates are saved as Date format in access, so when I use '#varStartDate#' I get a data type mismatch, but if I use #varStartDate# I get a syntax error!

Any ideas?

Cheers

 

[Cheech]

I use this select statement on an access database where datefields are defined as dates

"SELECT * FROM tblProducts WHERE fldIntent BETWEEN #" & strPreviousFirstDay & "# AND #" & strPreviousLastDay & "# ORDER BY fldAgreed, fldIntent DESC"

[Peace][Pipe]

 

[sinistapenguin]

Cheech

Are you putting this straight into the code or using the DMX recordset query?

Cheers

 

[lebisol]

it is the same....click on "advanced view" and paste it
then below u declare & Request your variable

(temp image)
All the best!

> need more info?
:: don't click HERE ::