Adding database last modified date

Hi,
you can do something like this:

1. Add a field named LastUpdated to the database table.
   
2. Set "Edit as" type for this field to "Hidden" and set default value to Now(). This field will store the timestamp of this record update.
   
3. On the list page use something like this to display database last updated date.
   set rsTemp = Server.CreateObject("ADODB.Recordset")
   
   rsTemp.Open "select max(LastUpdated) from TableName", dbConnection
   
   Response.Write rsTemp(0)

Many thanks for your response.

2 Issues:

1. I have entered the following code in a <td></td> and it didn't show anything, also not the text "Last Modified:". Do you recognize any problem?
   

2. I had in the database a field updated by hand called "Last_Updated". I want that the field will be updated by itself. I didn't find where to set the "Edit as" type for this field to "Hidden". Can you please direct me?
Many thanks

Make sure database connection is open at this moment and SQL query is correct (you can test itin MS Access).
EDIT AS type for this field can be set on the FORMATTING page in ASPRunnerPro.