Level 18
It's a DateTime object, so just use it ?
https://www.php.net/manual/en/class.datetime.php
hint : use format method
Apr 12, 2019
5
Level 13
Excel Import Date Format issue .
print date 2019-04-01 00:00:00 how to remove time format in date format
current i use
'Bill_Date' => \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($row['1'])
Level 13
@STEREOH - i cant properly understand can you just example of how to return only date not show time format
Level 18
@VANDAN - Well that's a shame ... all you had to do is click on the link, find the format method, click on it and you would have had all the examples.
'Bill_Date' => \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($row['1'])->format('Y-m-d')
1 like
Level 3
thanks it work for me on the assign answer as best.
Level 1
how about dates before 1970?
Please or to participate in this conversation.