How to read date data excel in PHP?

Question

I have an excel file. Date column is like this 29/01/21 that means dd/mm/yy.

I read file

$date2 = strtotime($row[1]);
            $date = date('d-m-Y',$date2);

Its result 000000000.

When I changed Y-m-d instead of d-m-Y. Its read but when date or mount greater than 12 its result is NULL.

How can I read this data correctly?

strtotime doesn't recognise dd/mm/yy format. Use php.net/manual/en/datetime.createfromformat.php instead. — ADyson
– ADyson, Commented Sep 30, 2021 at 8:20
Please read this for more details: How to parse a date string in PHP? — ADyson
– ADyson, Commented Sep 30, 2021 at 8:22

ADyson · Accepted Answer · 2021-09-30 08:30:19Z

1

Ok so here is a fix. strtotime can't read your dd/mm/yy format automatically. You have to re-order the date and add the century onto the year to make it yyyy/mm/dd:

$date2 = "29/01/21";
$d = explode("/",$date2);
$newDate2 = "20" . $d[2] . "/" . $d[1] . "/" . $d[0];
//echo $newDate2 . "\n";
$newDate = date('d/m/Y', strtotime($newDate2));
echo $newDate;

edited Sep 30, 2021 at 8:30

ADyson

62.9k16 gold badges88 silver badges100 bronze badges

answered Sep 30, 2021 at 8:21

Shlomtzion

7145 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

ADyson Over a year ago

OP is getting the date from the Excel sheet as 29/01/21, not 01-02-2021. It makes a difference.

ADyson Over a year ago

No we just need to use DateTime::createFromFormat - much less fiddly and less error-prone. No need to re-invent the wheel. php.net/manual/en/datetime.createfromformat.php, stackoverflow.com/questions/2767324/…

ADyson Over a year ago

Anyway, re-ordering it still wouldn't work, because the year is in two-digit format, so strtotime still can't parse it correctly. Demo: sandbox.onlinephpfunctions.com/code/… P.S. php.net/manual/en/datetime.formats.date.php explains the date formats which strtotime and other related functions can understand automatically.

ADyson Over a year ago

You could of course add the 20 to the start, but who knows if it was really supposed to be 19 or 21...but then that's a problem the OP will face regardless, so I think that's acceptable.

Shlomtzion Over a year ago

@ADyson - thanks! was about to do it...:)

|

Collectives™ on Stack Overflow

How to read date data excel in PHP?

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related