Hi, i managed it on my own, this is what I came up with, maybe it's usefull for one of you. It soure kept me busy. $datum_beginn="#$jahr/$monat_1/01#"; $datum_ende="#$jahr/$monat_1/$anzahl_tage_im_Monat#"; $datensatz_datum=odbc_exec($db_connection,"select * from Janbro_Termin where ((Datumsfeld >= $datum_beginn) and (Datumsfeld <= $datum_ende)) "); Jan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php