Setting DefaultValue for Datetime

[John_SC]

In SQL Server Express (Visual Studio 2010), I would like to set the default datetime field to the creation date & time for the record. Numerous posts indicate I should set the DefaultValue in properties to GetDate(). But this throws an error "Property Value is not valid - The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.

[GaryMazzone]

Show us the insert statement. Have you created a default for the columns? Are you just doing this in the SQL Statement?

[John_SC]

I am not doing it in code. I am just trying to set it in the Properties using the 'View Designer' (shows the relational view with the tables and fields). I select the field, which is a datetime, and try to set the DefaultValue property.

[GaryMazzone]

I don't use the UI I do this with SQL code in SSMS like this:

ALTER TABLE tableNameHere
    ADD CONSTRAINT [df_SomeNameHere] DEFAULT (GETUTCDATE()) FOR [ColumnNameHEre];
END

[John_SC]

Thanks for the guidance. I know I can do it that way, but I would like to do it in the UI.