title: Format a date like "20110822" in Google Open Refine (or Excel)?
body: <p>I have a dataset that has two different date formats in the same column.  Some are formatted like:  </p>
  
  <pre><code>2008-05-15T00:00:00Z
  </code></pre>
  
  <p>and others are formatted like:</p>
  
  <pre><code>20090804
  </code></pre>
  
  <p>Google Open Refine will recognize the first type as a date and will sort and allow me to perform other operations on it.  I can't figure out how to format the second type into a date.  A transformation of:</p>
  
  <pre><code>value.toDate()
  </code></pre>
  
  <p>throws an error, as does most everything else I try.  This seems like a simple problem but Googling is not helping.</p>