Hi, i've posted this in the general list, but I've got no answer. Well I'm still hoping there is one ;-) I've got the following code: $datum_beginn="2002-12-12"; $datensatz=odbc_exec($db_connection,"select * from Termin where Datumsfeld >'#$datum_beginn#'"); I get an error message that data in criteria doesn't match. (free translation) The error def. lays in Datumsfeld >'#$datum_beginn#'. How do I get a list of all entries with a date that lay behind a certain date? I'd prefer to let the database do the job for me, rather than pulling everything out and get the relevant data with php. The field Datumsfeld is a date field with the syntax DD.MM.YYYY (German way) thx Jan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php