datetime stamp

[jldavis5]

Would anyone know how I could datetime stamp a record in a database results page eveytime the record is updated. I'm using SQL server and tried to do this by adding a colum in the table I'm editing that has the formula getdate() but updates every row when I try and edit one. Any ideas would be helpfull

 

[link9]

add the column to the database, and then just tack on the value in the INSERT statement...

INSERT INTO table (val1, timeStamp) VALUES ('myVal',getDate());


paul

 

[Guest_imported]

add new column as paul said.
use: "UPDATE myTable SET val1='myValue',updateDate=getDate()
WHERE id (unique identifier)=" & recID