title: Set Date/Time to 00:00:00
body: <p>I have an array of dates with different times in the date.</p>
  
  <p>Example: {4/15/13 05:00:00, 03/10/13 13:00:00, 02/10/13 02:00:00, etc.}</p>
  
  <p>If I wanted to change just the hour to 00:00:00 so the array would read:</p>
  
  <p>{4/15/13 00:00:00, 03/10/13 00:00:00, 02/10/13 00:00:00, etc.}</p>
  
  <p>How would I do that?</p>
  
  <p>I've tried using getTime(), but I don't have control over just the hours. Any help would be great.
  Thanks!</p>
  
  <p>EDIT: I tried this loop:</p>
  
  <pre><code> for (var i = 0; i &lt; gValues.length; i++) { // repeat loop
      sheet.getRange(i + 2, 7, 1, 1).setValue(gValues[i][0].setHours(00,00,00,00));
    }
  </code></pre>
  
  <p>But instead of the desired result, I get this value: "12/20/5828963 0:00:00" for every single cell.</p>