Hi,
I am using PHP ODBC functions to access an MS Access database. I have a form that inputs a start and end date from the user, and I want to make a select statement that would filter and list the records that has the date field (of type datetime) within the specified date range. How can I put the date in the correct format in the WHERE clause of the SELECT statement.
Thanks,
Victor.
I am using PHP ODBC functions to access an MS Access database. I have a form that inputs a start and end date from the user, and I want to make a select statement that would filter and list the records that has the date field (of type datetime) within the specified date range. How can I put the date in the correct format in the WHERE clause of the SELECT statement.
Thanks,
Victor.