title: conversion of a varchar datatype to a datetime datatype resulted in an out-of-range value
body: <p>The conversion of a varchar datatype to a datetime datatype resulted in an out-of-range value</p>
  
  <pre><code>select a.DLNO,
         a.NAME,
         b.TOPSTRING,
         Convert(datetime,a.DOB,103) as DOB, 
         Convert(datetime,a.DOI,103) as DOI,
         Convert(datetime,b.datepushed,103) as datepushed 
  from    
         PLInfo_Demo a,DLInfo_Demo b 
  where 
         a.dlno=b.DLNO
  </code></pre>