How to organize search by date?

Question

Yii

There is a
datatime= 2018.05.18 format field,
how can I find the date range from 05/01/2018 to 05/20/2018 with an Activerecord query?

Answer 1

$query = TvojaModel::find()
->where(['>=', $column_1, '2018-05-01'])
->andWhere(['<=', $column_2, '2018-05-20'])
->all();

Answer 2

$query = Model::find()
->where(['between', 'datatime_column', '2018-05-01', '2018-05-20']);

Read the details in the documentation