title: Inserting default value for null dates in sql server
body: <p>I have a table with null-able dates. This has a default constraint of getdate(). If a date is not supplied today's date is inserted.  However, I want to convert null's to todays date as well.</p>
  
  <p>Is there a way to force the date to today's date when a null is supplied on an insert.</p>
  
  <p><em>I do  not want to change this to a non-nullable field.</em></p>