Hi guys, I need to have the user enter a starting date
and an ending date to pass to the SQL server for
retrieving invoices. I'm just having trouble with the
datatypes and conversions.

Should I obtain the users input as a string?? Or should
I set the users input to a date datatype. I want the
user to be able to enter the date in this format
mm/dd/yyyy.

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

The table.column_name is Armast.finvdate, and my
variables are strStartDate & strEndDate.

This SQL statement will be embedded in the VBA behind
Excel... but I have to get it right:

WHERE CONVERT(CHAR(10),Armast.finvdate,101) BETWEEN
strStartDate AND strEndDate

What is the best way to do this? What datatypes should I
declare the StartDate & EndDate? And should I convert
Armast.finvdate to match the variables or convert the
variables to try and match SQL standard date format?

DBAL