How to properly set up range date filter in SonataAdminBundle?

Question

symfony

Who is familiar with SonataAdminBundle do not pass by)
There is a filter in the Admin class

protected function configureDatagridFilters(DatagridMapper $datagridMapper)
    {
        $datagridMapper
            ->add('createdAt', 'doctrine_orm_date_range', array('field_type'=>'sonata_type_date_range_picker',))
                ;
   }

But it does not work, 2 fields appear with From date and End date and with the ability to select a date in the datepicker. After I apply a filter over these fields, it gives out This value is not valid and, accordingly, does not filter anything. As I understand it, it cannot parse the date.

Answer 1

This is due to the fact that sonata intl is connected.
We need to make the same format for picker and backend.

->add(
    'createdAt',
    'doctrine_orm_date_range',
    [],
    'sonata_type_date_range_picker',
    [
        'field_options_start' => [
            'format' => 'dd.MM.yyyy'
        ],
        'field_options_end' => [
            'format' => 'dd.MM.yyyy'
        ]
    ]
)