PHP Date Question

[bCourtney07]

Here is my select statement

SELECT Employee_ID, Miles, Activity, Minutes, Date 
FROM Activity_Log 
WHERE Employee_ID = '{$_POST["Employee_ID"]}'

 

I'm using a MS Access Database with an adodb dsn-less connection.

 

<?php
$conn = new COM ("ADODB.Connection") or die("Cannot start ADO");
$connStr = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=F:\Wellness Program\HR Employee Wellness Program.mdb;";
$conn->open($connStr); //Open the connection to the database
?>

 

 

I want to narrow it down so it'll select information that is dated 01/02/2008 to 08/15/2008.  How can I accomplish this?  ???

[revraz]

Change your date to something you can use, then you can do

 

WHERE `date` > 2008/01/02 AND `date` < 2008/08/15

[bCourtney07]

Warning: (null)(): Invoke() failed: Exception occurred. Source: Microsoft OLE DB Provider for ODBC Drivers Description: 
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Employee_ID = 'bcourtney' 
WHERE Date > 01/02/2008 AND Date < 08/15/2008'. in F:\InetPub\wwwroot\WellnessProgram\DisplayProgress2.php on line 10

 

???

 

What am I doing wrong?

[bCourtney07]

I must just be completely stupid because i can't figure this out.

 

I would greatly appreciate any help  :-\

[revraz]

For one, you can't compare in that date format.

 

Look how I displayed it and how you are.

 

Second, I don't know what ODBC is expecting as operators.