title: Trying to show datediff greater than ten days
body: <p>I'm trying to create a SQL statement, which calculates how many days a delivery of  undelivered products are delayed relative to the current date. The result should show the order number, order date, product number and the number of delay days for the order lines where the number of days of delay exceeds 10 days.</p>
  
  <p>Here is my SQL statement so far: </p>
  
  <pre><code>SELECT 
      Orderhuvuden.ordernr, 
      orderdatum, 
      Orderrader.produktnr,
      datediff(day, orderdatum, isnull(utdatum, getdate())) as 'Delay days'
  FROM 
      Orderhuvuden 
  JOIN 
      Orderrader ON Orderhuvuden.ordernr = Orderrader.ordernr AND utdatum IS NULL
  </code></pre>
  
  <p>What I have a problem with is to solve how to show the delayed days that exceeds 10 days. I've tried to add something like: </p>
  
  <pre><code>WHERE (getdate() - orderdatum) &gt; 10
  </code></pre>
  
  <p>But it doesn't work. Does anyone know how to solve this last step?</p>