This is much better and is giving me the date in the fommat #04/12/07# which is conflicting with the database value which include time and im recieving an err "not a valid month". i don't want to change my date format to include time cause i want to query all accounts modified today. any suggestions