Drupal 7 Trying to create a "Today in History" view
Try to use hook_views_query_alter.

Even though, I think you can do it using only views without altering the query.
Maybe using Date Views module would help.