I'm using PHPExcel_Reader to import data into MySQL. One of the columns in Excel file is Date_Of_Birth.
I've tried many methods to no avail. I'm afraid, google search has not yielded any desirable result either.
In the script, I have:
$date_of_birth = "";
$date_of_birth = date('Y-m-d', strtotime($Row));
In Excel file, the date format is: DD-MM-YYYY (31-12-1999). After upload, it reads: (1970-01-01). It appears it's not seen 31 as Day but Month.
In fact, when I used 11-12-2001 (December 11, 2001), I still got 2001-11-12 (November 12, 2001).
Please, how can I get through this irrespective of the date format in Excel file?