I have recently moved from using MS Access to a MySQL database. Within this database I have a field called LinkExpired that is defined as datetime.
If I use the following asp with MS Access it works fine
<pre id=code><font face=courier size=2 id=code> "SELECT * FROM tblLinks WHERE (tbllinks.LinkExpired &gt;= '" & now() & "') ORDER BY LinkID DESC"</font id=code></pre id=code>
However even though some records in my LinkExpired field are in the past they are still being called in the recordset.
I assume that this is because of the different formating of the now() asp function and datetime field setting but does anybody know how to fix it.
Many thanks

try date or getdate instead of now

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]