Hi, I am trying to compare dates between my form fields and my db field but so far keep getting a format error.. Am using an Oracle Db...
my query reads like this: SQL = "SELECT DISTINCT to_char(DOCUMENT.doc_date,'dd/mm/yyyy') doc_date,DOCUMENT.document_code from Document where"; SQL += " doc_date BETWEEN '15/11/1258' AND '15/08/1988 '"; can anyone pl tell me whats wrong up here?? TIA, sands -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php