Thanks Jamie, I will try and work with this on Monday..
THanks alot. DBAL



-----Original Message-----
"DBAL" wrote ...

I need to have the user enter a starting date
and an ending date to pass to the SQL server for
retrieving invoices.

I tried to convert the invoice date to a string for
comparison with my variables but it didn't work.

My preferred approach is to store in memory as a VBA
Date type and use
an unambiguous date string in sql code e.g.

WHERE MyDateCol BETWEEN
'01 JUN 2004' AND '30 JUN 2004'

This SQL statement will be embedded in the VBA behind
Excel...

My preferred approach is to use a stored procedure e.g.

CREATE PROCEDURE
MyStoredProc (
start_date DATETIME,
end_date DATETIME
)
AS
SELECT
RefID,
DateEffective,
Earnings
FROM
EarningsHistory
WHERE
DateEffective
BETWEEN start_date AND end_date;

and call it from Excel using e.g.

EXEC MyStoredProc '01 JUN 2004', '30 JUN 2004'

Jamie.

--
.