Encounter date in phpspreadsheet

I don't understand, you should know the data type of the column it seems. Can you be more detailed? And even if the column was a date but people entered it as text, you could still use some string functions to properly format it to a mysql date format.

@jlrdw Thanks for the answer

I am using phpspreadsheet library to convert XLS file,and I am using PHP Date time object to convert dates, but how can I encountered which fields has date or not ?

I am using below code to convert dates

$value = $worksheet->getValue();
$date = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($value);

https://laravel.com/docs/5.5/helpers#strings

and

http://php.net/manual/en/ref.strings.php

and

http://php.net/manual/en/function.date.php

I still don't understand, it seems you should know data types you are dealing with. I.e., which column is a date. How can you not know that.

I would tell whoever you are doing this for, look I need data types.

No data types = me no program for you.