title: SQL Server inserting Date as 1/1/1900
body: <p>I am having ASP Classic page to insert record in table. 
  I am using form element for 5 fields viz.  [ABC] ([code], [updatedate], [flag], [Mfdate]. And using the date control to get user selected date in Mdate when user does not select the Mdate, the query that it is getting formed in my ASP page is as below</p>
  
  <pre><code>INSERT INTO [ABC] ([code], [updatedate], [flag], [Mfdate]) 
  VALUES('203 ', '6/12/2013', 'N/A', '')
  </code></pre>
  
  <p>When it is run in SQL Server it is inserting date <code>1/1/1900</code> for <code>Mfdate</code> but User has not selected any value.</p>
  
  <p>Why is it happening like this?</p>
  
  <p>The  data type for <code>Mfdate</code> is <code>datetime</code>.</p>