How to get historical content having historical date that happened in current week in Views?
I used DAYOFYEAR function.

$startDateNumber = date('z', strtotime("-4 days"));
$endDateNumber = date('z', strtotime("+3 days"));

$query = db_select('field_data_field_historical_date', 'fd');
$query-&gt;fields('fd');
$query-&gt;where('DAYOFYEAR(fd.field_historical_date_value)&gt;=:startDate', array(':startDate' =&gt; $startDateNumber));

$or = db_or();
$or-&gt;where('DAYOFYEAR(fd.field_historical_date_value)&lt;=:endDate', array(':endDate' =&gt; $endDateNumber));

$nid = $query-&gt;condition($or)-&gt;execute()-&gt;fetchField(3);

if (!is_bool($nid)) {
    print_r($nid); exit;
} else {
    print 'no';
}