Yii2 DateTimePicker not working in filter

I add a Datepicker Filter (not DateTimepicker) and wanna filter "is equal" to "2014/09/11" the Grid don't wanna display anything - Problem ist that the filtered Date is "2014/09/11 00:00", which isn't equal because of the time - how can I fix this issue?

db

I want to search by date only

index.php

<?php

use yii\helpers\Html;
//use yii\grid\GridView;
use kartik\grid\GridView;
use dosamigos\datepicker\DatePicker;
use yii\helpers\ArrayHelper;
use backend\models\Orders;
/* @var $this yii\web\View */
/* @var $searchModel backend\models\OrdersSearch */
/* @var $dataProvider yii\data\ActiveDataProvider */

$this->title = 'Orders';
$this->params['breadcrumbs'][] = $this->title;
?>
<div class="container">

    <h1><?= Html::encode($this->title) ?></h1>

  

    <?php // echo $this->render('_search', ['model' => $searchModel]); ?>

    <?= GridView::widget([
        'dataProvider' => $dataProvider,
        'filterModel' => $searchModel,
        'showPageSummary' => true,
        'rowOptions'=>function($model){
            if($model->orderStatus == 'delivered')
            {
                return ['class'=>'success'];
            }
        },
        'columns' => [
          
            ['class' => 'yii\grid\SerialColumn','header'=>'No','headerOptions' => ['style' => 'color:black']],
            
            'orderId',
            [
                'attribute'=>'customerId',
                'label'=>'Customer Name',
                'value'=>'customer.customerName',
            ],
            //'deliveryDate',
            [
                'attribute'=> 'deliveryDate',
                'value'=>'deliveryDate',
                'format'=>'raw',
                'filter'=>DatePicker::widget([
                    'model' => $searchModel,
                    'attribute' => 'deliveryDate',
                    
                ])

            ],
            'address',
            'orderStatus',
            'quantity',
            [
                'attribute' => 'sum',
                'format' => 'currency',
                 'pageSummary' => true,
            ],

            ['class' => 'yii\grid\ActionColumn','header'=>'Actions','headerOptions' => ['style' => 'color:black']],
          
        ],
    ]); ?>


</div>

OrdersSearch.php

<?php

namespace backend\models;

use yii\base\Model;
use yii\data\ActiveDataProvider;
use backend\models\Orders;
use Yii;
/**
 * OrdersSearch represents the model behind the search form of `backend\models\Orders`.
 */
class OrdersSearch extends Orders
{
    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['id', 'quantity'], 'integer'],
            [['orderId', 'deliveryDate', 'address', 'orderStatus','customerId','staff_id'], 'safe'],
            [['sum'], 'number'],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function scenarios()
    {
        // bypass scenarios() implementation in the parent class
        return Model::scenarios();
    }

    /**
     * Creates data provider instance with search query applied
     *
     * @param array $params
     *
     * @return ActiveDataProvider
     */
    public function search($params, $pageSize)
    {
        $query = Orders::find();

        // add conditions that should always apply here

        $dataProvider = new ActiveDataProvider([
            'query' => $query,
            'pagination' => [
                'pageSize' => $pageSize,  // no pagination if it is 0
            ],
        ]);

        $this->load($params);

        if (!$this->validate()) {
            // uncomment the following line if you do not want to return any records when validation fails
            // $query->where('0=1');
            return $dataProvider;
        }

        $query->joinWith('customer');
        $query->joinWith('user');

        // grid filtering conditions
        $query->andFilterWhere([
            'id' => $this->id,
            'deliveryDate' => $this->deliveryDate,
            'quantity' => $this->quantity,
            'sum' => $this->sum,
        ]);

        $query->andFilterWhere(['like', 'orderId', $this->orderId])
            ->andFilterWhere(['like', 'address', $this->address])
            ->andFilterWhere(['like', 'customers.customerName', $this->customerId])
            ->andFilterWhere(['like', 'user.username', $this->staff_id])
            ->andFilterWhere(['like', 'deliveryDate' ,$this->deliveryDate])
            ->andFilterWhere(['like', 'orderStatus', $this->orderStatus]);

        return $dataProvider;
    }

    public function searchStaff($params, $pageSize)
    {
        $query = Orders::find()->where(['staff_id'=>Yii::$app->user->id]);

        // add conditions that should always apply here

        $dataProvider = new ActiveDataProvider([
            'query' => $query,
            'pagination' => [
                'pageSize' => $pageSize,  // no pagination if it is 0
            ],
        ]);

        $this->load($params);

        if (!$this->validate()) {
            // uncomment the following line if you do not want to return any records when validation fails
            // $query->where('0=1');
            return $dataProvider;
        }

        $query->joinWith('customer');
        $query->joinWith('user');

        // grid filtering conditions
        $query->andFilterWhere([
            'id' => $this->id,
            'deliveryDate' => $this->deliveryDate,
            'quantity' => $this->quantity,
            'sum' => $this->sum,
        ]);

        $query->andFilterWhere(['like', 'orderId', $this->orderId])
            ->andFilterWhere(['like', 'address', $this->address])
            ->andFilterWhere(['like', 'customers.customerName', $this->customerId])
            ->andFilterWhere(['like', 'user.username', $this->staff_id])
            ->andFilterWhere(['like', 'deliveryDate' ,$this->deliveryDate])
            //->andFilterWhere(['like', 'DATE_FORMAT(deliveryDate,"%Y-%m-%d")' , date('Y-m-d' , strtotime($this->deliveryDate))])
            ->andFilterWhere(['like', 'orderStatus', $this->orderStatus]);

        return $dataProvider;
    }
}

source https://stackoverflow.com/questions/69362213/yii2-datetimepicker-not-working-in-filter