Has anyone ever done a time stamp on a web site. For example when a job is closed (option within a drop down menu) I want it display the date and time of when the job was closed in the record and displayed on the page. Thanks in adavance for any help.

If jobclosed then
   rs.fields("closed") = now()
End if

response.write("Job closed on " & rs.fields("closed"))

How come it doesn't add it to the field in the database and why does it always display the current time upon refresh. Thanks for the help.

This is the code I am using on the page now slightly modified.

If RS("spec_call_status") = "Closed" then
         RS("spec_closed_time") = now()
End if

Alright, i'll take the time to write an entire script. You need to have a variable set to the job ID called "jobidn"

Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.provider = "Microsoft.Jet.OLEDB.4.0"
conn.open "put your database path here!!!"

'I'm going to update the current record...
strSQL = "UPDATE yourtablename SET isjobclosed='yes', timejobclosed ='" & now() & "' WHERE jobid = '"& jobidn "';"

conn.close
Set conn = NOTHING

Anything in italics might need to be changed