now() 1

[realhorrorshow]

I have the statement: WHERE EntryDate >= (now() - 60) . I am using this to filter records into a 'new on the database' section. It works fine offline but not online. Online it sometimes displays all results or none of the results, never filtered. I put <%now -60%> on the page so i know it's getting the correct dates.

I have a feeling it could be a date format conflict. I checked throught the sql admin window what it was (2000-12-24) and changed my regional settings accordingly to make it appear the same in access. Still no joy. I am using an access DB converted into mysql.

Thanks

Tim

 

[qmi]

try

WHERE to_days(EntryDate) >= to_days(now())-60