Column Default Date

Column Default Date

Column Default Date

I am trying to write a database creation script and on one table I need to assign a default date to a column of data type "DATETIME YEAR TO MINUTE". I wish to assign the current date. Any help would be great!

RE: Column Default Date

Thanks for the reply, I'll explain futher what I am trying to do:I have a SQL script which creates the database and tables (I'm importing data afterwards using the MS-DTC from another DBMS)Below you'll find the troublesome table, I have made the problem line in RED