Laravel-excel: Why my date column always return int value?. How can I get the origin value? because its int value is wrong.

[TheThai212]

ex:

• my date column: 12/20/2018;
  when i dd($row['date']) it return 43454.705023148
  and it is not the value of 12/20/2018 when converted to a int. it is "1970-01-01 20:04:14"
  how to fix it? thanks!

[issue-check[bot]]

Thanks for submitting the ticket. Unfortunately the information you provided is incomplete. We need to know which version you use and how to reproduce it. Please include code examples. Before we can pick it up, please check (https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/.github/ISSUE_TEMPLATE.md) and add the missing information. To make processing of this ticket a lot easier, please make sure to check (https://laravel-excel.maatwebsite.nl/docs/3.1/getting-started/contributing) and double-check if you have filled in the issue template correctly. This will allow us to pick up your ticket more efficiently. Issues that follow the guidelines correctly will get priority over other issues.

[TheThai212]

I'm using laravel excel 3.1 and php 7.1

[GlennM]

Please fill in the issue template with all the required information if you would like to receive support.

Based on the info now, I'd suggest reading https://laravel-excel.maatwebsite.nl/3.1/exports/column-formatting.html / https://laravel-excel.maatwebsite.nl/3.1/imports/custom-formatting-values.html and see if that helps.

[enltguy]

$now = date('m/d/Y')

[MacDino]

yeah i have the same question .
i'am reading https://laravel-excel.maatwebsite.nl/3.1/imports/custom-formatting-values.html and try to use bindValue to fix it .but it not work.
i find someone commit a bug maybe find why https://github.com/Maatwebsite/Laravel-Excel/issues/1907

[patrickbrouwers]

PhpSpreadsheet doesn't support value binders on imports. This is a mistake in our documentation.

For date conversion, you are most likely dealing with an excel timestamp. You can try to convert using:

\PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($row['date'])

[TheThai212]

i just delete old value and format this column in Category:custom yyyy-mm-dd. it's working.

[insign]

PhpSpreadsheet doesn't support value binders on imports. This is a mistake in our documentation.

For date conversion, you are most likely dealing with an excel timestamp. You can try to convert using:

\PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($row['date'])

This was a lifesaver after a lot of research