title: SSIS expression for date comparison?
body: <p>My expression is like following:</p>
  
  <pre><code>DATEDIFF("dd",(DT_DATE)(SUBSTRING(@[User::strExcelFileName],15,2) + "-" + SUBSTRING(@[User::strExcelFileName],18,2) + "-" + SUBSTRING(@[User::strExcelFileName],21,4)),GETDATE()) &gt; @[User::intDaysCount]
  </code></pre>
  
  <p>My file : TempConfigPr_06172013.xlsx</p>
  
  <p>The problem is it's saying error while converting from "DT_WSTR" to data type "DT_DATE"...Could any one please help, where I'm going wrong and how to solve this?</p>
  
  <p>Note: I checked,this expression is working fine.</p>
  
  <pre><code>DATEDIFF("dd",(DT_DATE)("11-18-2010"),GETDATE()) &gt; @[User::intDaysCount]
  </code></pre>