Originally Said By: Jason Byrnes
in the recordset for the results page, you would need to use the MySQL DATE_FORMAT() function to return the date formatted as only the Y-m-d portion.for example:
SELECT *, DATE_FORMAT(dateColumn, "%Y-%m-%d") as formatedDate FROM tblName
then in the Database Search criteria for the date search, use the formatedDate aliased column
Nice thought, but it doesn't work. Unknown column 'formatedDate' in 'where clause'
This works:
SELECT *, DATE_FORMAT(dateColumn, "%Y-%m-%d") as formatedDate FROM tblName WHERE DATE_FORMAT(dateColumn, "%Y-%m-%d") = [search date]
but I don't know how I could get WADB to do that.
