Hi Jason,
Thank you for your reply.
I have carried out your instructions and I can see that the SQL is being run using the recordset echo command as you directed.
I have also installed the MySQL Tools Query Browser and took that SQL command being used in the recordset and ran it directly and I get no data result.
I'm not sure why it isnt working?
If I insert a record into the table with the following value in dueDateTime of "2009-11-02 20:35:00" and run the following SQL in the query browser:
SELECT * FROM tasks WHERE tasks.dueDateTime = DATE_FORMAT(NOW(), '%d-%m-%y %h:%m')
and I wait for the computers clock to reach 20:35 and run the query at that time nothing is retrieved from the databse.
If I run the following SQL in the query browser:
SELECT * FROM tasks WHERE tasks.dueDateTime = "2009-11-02 20:35"
The record is retrieved and shown.
it's like the NOW() function isnt working as it doesnt appear to be using the current date/time of the computer (which is also where the MySql database is running from).
if I do a cmd prompt DATE on the computer I get: 02/11/2009
if I do a cmd prompt TIME on the computer I get: 20:35:23
I'm unsure as to why it isnt working!