title: convert ssis expression datetime to int
body: <p>I want to calculate last friday's date in ssis. Below code is doing it.</p>
  
  <pre><code>DATEADD("dd", -1 - (DATEPART("dw", getdate()) % 7), getdate())
  </code></pre>
  
  <p>But it gives results for datetime datatype and I want results for int data type in ssis.</p>
  
  <p>How to convert?</p>
  
  <pre><code>DATEADD("dd", -1 - (DATEPART("dw", getdate()) % 7), getdate())
  </code></pre>