How to read 2 date formats in laravel-excel (maatsweb v 2.1)

I am using Laravel excel (maatsweb excel v 2.1 https://docs.laravel-excel.com/2.1/import/dates.html) and laravel 5.5.

I have an issue when the field is date and there are 2 formats.

The first format is visible when opening the xcel with an xcel reader like LibreOffice. Lets say the user sees date as "02 Jan 2022"

The second format is visible when I click on the date cell - it shows another format. Lets say "01/02/2022"

When I call

$this->excelObj->get()

this returns one format (lets say "01/02/2022") But when I read the same file with

$this->excelObj->chunk(..

It returns the other format ("02 Jan 2022")

How can I have it read the same way? Is there a setting to make them behave the same?

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2jEDXI5
via IFTTT