I have a table with three fields. The second field is a date field.
How do I set a default value of todays date in the table design grid?

CEJ

__________________
CEJ

Simply select the column in design view and enter an expression for the current date in the 'Default Value' entry on the properties page in the 'Columns' portion of the lower screen.

Thus, a default value of getdate() will set the value of the column top right now if no value is supplied when a row is inserted.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

CREATE TABLE dbo.TABLE1
(
  field1 ...
  ,field2 smalldatetime defualt getdate()
  ,field3 ...
)

Always:),
Hovik Melkomian.