I was hoping you help, I have a ms access database on my webserver. I want to select all the records with a certain date. But it seems not to work.
<CFQUERY NAME="qStuff" DATASOURCE="MyDb" maxrows="20"> SELECT * FROM Stuff; WHERE (((Stuff.RegDate)=#5/1/2004#)); </CFQUERY>
When I do this in MSAccess sql view it works but doesn't work on cfm page. Please help:'( I have also tried shifting the date formats.