ActiveRecord выборка за промежуток времени

// За день
$Articles = Articles::find()->where('date_create >= CURDATE()')->all();

// За вчера
$Articles = Articles::find()->where('date_create >= (CURDATE()-1) AND date_create < CURDATE()')->all();

// За неделю
$Articles = Articles::find()->where('date_create >= DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)')->all();

// За месяц
$Articles = Articles::find()->where('date_create >= DATE_SUB(CURRENT_DATE, INTERVAL 1 MONTH)')->all();