Hi!

Specify the GetDate() funtion as a default value of the field. In the Enterprise manager you can do this by using the "Default Value" field at the bottom pane of the table designer.

HTH.

>Hello, All
>
>I've runned into one problem:
>
>I've defined a table with a DateTime column in MSDE. I want every update of a record in that table to update automatically the DateTime field, using the server's current date and time.
>
>I wonder if there is a way to specify this (maybe default value, or something like this).
>
>Can anyone help me?
>
>Thank you