title: Departure Date after Arrival Date
body: <p>This is probably a simple answer but I don't know it, how do I make sure the Departure is after the Arrival date.</p>
  
  <p>Thanks</p>
  
  <p>Wayne</p>
  
  <pre><code>DATEADD(day, ABS(CHECKSUM(NEWID()) % 365), '1 Jan 2010') as ArrivalDate,
  DATEADD(day, ABS(CHECKSUM(NEWID()) % 365), '1 Jan 2010') as DepatureDate,
  </code></pre>