title: how to solve 1753 year issue in sqlserver?
body: <p>I am using sqlserver to store/search. The problem is I have a form which takes start date and end date to search. If I enter dates after 1753 then no problem. If I enter any date below 1752, I am getting the below exception:</p>
  
  <pre><code>The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. 
  </code></pre>
  
  <p>I know sql server supports date range b/w 1753 and 9999. But I cannot prevent the user from entering dates below 1753. Please help me.</p>
  
  <p>Thanks!</p>