title: Magento "Special Price From Date" not working
body: <p>We use Magento 1.7.0.2.</p>
  
  <p>Now we have a promotion calendar with products (offline) which should be visible for one day as a promotion on the frontpage of the shop.</p>
  
  <p>We have two attributes "Special Price From Date" and "Special Price To Date" with the date on which the product should be displayed on the home page.
  We also have an attribute "Special Price" in which we enter the promotional price .</p>
  
  <p>Example:</p>
  
  <pre><code>Today is 09.12.2013
  
  "Price" = 200
  "Special Price" = 180
  
  "Special Price From Date" = 10.12.2013
  "Special Price To Date" = 10.12.2013
  </code></pre>
  
  <p>Now the product should be displayed on the home page and available for the special price of 180 on 10.12.2013.</p>
  
  <p>If I search the product on 10.12.2013 via category filter in the frontend the price of the product is actually reduced to 180 as it should be. The problem is now that the product is indeed displayed on 10.12.2013 on the front page, but with the old price of 200.</p>
  
  <p>I have found a solution for that: I have to wait until the day concerned, edit the product and then click "Save" again. Then the product appears on the home page with the promotional price. But you may understant that we can not save each affected product every day again. The "Special Price From Date" should exactly do that, shouldn't it?</p>
  
  <p>What I have already tried:</p>
  
  <pre><code>- Call cron.php via cronjob call 1x per day
  - Call indexer.php reindexall via cronjob 1x per day
  - Calling a script 1x per day via cronjob which deletes all caches
  </code></pre>
  
  <p>Unfortunately everything does not work.
  Does anyone know what I'm doing wrong here?</p>
  
  <p>I thought about corrupted tables or stuff like that, what about executing a script like that once a day?</p>
  
  <pre><code>$tables = $db-&gt;query('SHOW TABLES');
  
  foreach ($tables as $table)
  {
      $db-&gt;query("ANALYZE TABLE {$table}");
      $db-&gt;query("OPTIMIZE TABLE {$table}");
  }
  </code></pre>