You can use a constant expression as a default value, as long as it does not reference database objects. For example, the following expression allows column defaults to contain the date fifteen days from today:

... DEFAULT ( DATEADD( day, 15, GETDATE() ) );