title: How to automatically format NOW() in to a string that that displays YYYY-MM-DD?
body: <p>Is it possible to format the output of NOW() to a string that displays <code>YYYY-MM-DD</code>?</p>
  
  <p>This is the output of NOW(): <code>29/02/2012 12.07.37</code></p>
  
  <p>The reason is, that I need to use the current date in a QUERY. </p>
  
  <p>QUERY only accepts date in the format YYYY-MM-DD . I can't get a date directly from a cell, because it gets formatted as (even if I change the formatting): <code>DD/MM/YYYY</code></p>
  
  <p>Perhaps some regular expression?</p>