How to select date column

[r123k]

I am using EXCEL VBA and SQL statement to try to select some data in worksheet

Below is my worksheet sample

datee name product_name product_code
2014/6/1 Eric Toy_A C0001
2014/6/3 Stephen Toy_B C0003
2014/6/16 Calvin Toy_C C0003
2014/6/19 Perry Toy_D C0001
2014/6/23 Calvin Toy_E C0002

Here is my code segment for select data

strQuery = "SELECT * FROM[List$] where promoter_name = 'Calvin' and promoter_code = 'C0003'"
Set rs = cn.Execute(strQuery)

This is success to select data with no error

============================
But when I changed the condition to use datee column

strQuery = "SELECT * FROM[List$] where promoter_name = 'Calvin' and datee = '2014/6/23'"

It cannot work
The error message said data type incorrect

How can I do?
Do I need to set any thing before run the sql?

[sktneer]

Try to see if this works....

Please Login or Register  to view this content.

[r123k]

I just tried , but its not work
Display error message about query string error

[sktneer]

I think the quotation mark around the date is causing error because date is number not text so try to remove the single quote around the date to see if this works.

[r123k]

strQuery = "SELECT * FROM[List$] where promoter_name = 'Calvin' and datee = 2014/6/23"

Don't show any error but It cannot select any data =;="

[r123k]

I just try successful between date using #
Thanks first~

I want to ask one more question
if I want to input a variable in select query. How can I do?

I tried
strQuery = "SELECT * FROM[List$] where promoter_name = '& v_name &' and datee = 2014/6/23"
But cannot work