Worked in Access, but not in MySQL
Posted on 2003-11-10
Can anyone tell me why this worked using Access, but doesn't when using MySQL?
<cfset currentDate = CreateODBCDate(Now())>
<cfquery name="bulletinBoard" datasource="intranet2">
WHERE (CATEGORY = 'Bulletin Board' AND SUBMITTED >= #currentDate-90#)
ORDER BY SUBMITTED DESC, ID DESC</cfquery>
This is supposed to return all of the entries within the database from the Bulletin Board in the last 90 days.