title: Converting Varchar to Datetime using 'yyyymmdd' format
body: <p>I am working with a date processing procedure. The dates that are coming in from a file are formatted as 'yyyymmdd' and need to be converted to a DATETIME data type for use with built in date functions such as dateadd or datepart.</p>
  
  <p>CONVERT(DATETIME,datestring) - Throws an error 'Arithmetic overflow error converting expression to data type datetime.'</p>
  
  <p>I have thought about splitting the string into separate sections and recombining them to form a valid datetime stamp but would like to avoid this IF possible.</p>
  
  <p>Any other ways to convert from this varchar format to a date or datetime?</p>