hi Chris!

thanks for the input. apparently i have tried also adding the quotes around the datetime field, still it did not work. btw, im using SQL Server 7. the field that i'm updating in the table is in datetime format and im replacing the old value with the now() value. i am not sure how to do this. any suggestions?

thanks!