How To Select Date Column

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

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