Thanks All, i have confirmed that the IIS server, the SQL server and the web view client pc are all in the same time zone and have the same time...

HI I would agree, but i have been doing some investigations and if i reference an already populated field (by the web page previoulsy) as the input to the datetime...

Thanks for all the replies, looks like im snookered then! still dont understand why if the asp code is affecting the data, when it writes to the db and i...

this is the stored procedure i think it is called either by the asp page in the web server or by a java widget in the web server. thanks agian...

HI yes i have i think got the query that is raised from the web page, it calls a stored procedure (incidentactivityinsert) that inserts the values defined, as variables. one...