title: Magento Set Grid to Filter Automatically by Current Day using Existing Datetime Column in Grid
body: <p>In Magento I'm creating a custom module and would love to be able to filter automatically by the datetime column so that the intial grid listing shows only entities related to "todays" date.</p>
  
  <p>Here is my datetime column:</p>
  
  <pre><code>$this-&gt;addColumn('ts', array(
      'header'    =&gt; $hlp-&gt;__('Activated'),
      'align'     =&gt; 'left',
      'index'     =&gt; 'ts',
      'type'      =&gt; 'datetime',
      'width'     =&gt; '160px',
  ));
  </code></pre>
  
  <p>I'm think there should be a way for me to just add a filter to the collection like so:</p>
  
  <pre><code>$now = Mage::getModel('core/date')-&gt;timestamp(time());
  $dateTime = date('m/d/y h:i:s', $now);
  
  $collection = Mage::getModel('mymodule/items')-&gt;getCollection()
     -&gt;addFieldToFilter('ts', $dateTime);
  </code></pre>
  
  <p>But this doesn't work?</p>
  
  <p>Am I using the wrong filter? My "ts" field in the database is a "datetime" field, but the default magento "From: " - "To:" date range selectors don't use hours, minutes, seconds.</p>
  
  <p>Any ideas?</p>
  
  <p>Thanks,
  Tegan</p>