PHP parse date column from excel sheet (CSV)

Question

I created CSV file having date field in format 12-08-2018. When I opened csv file in Excel sheet it displays and saves in format 12/AUG/2018 to file.

When I am trying to parse it gives me wrong:

<?php
     echo date('Y-m-d',strtotime('12/AUG/2018')); // 1969-12-31
?>

So, What could be the best way to handle parsing of date coming form excel sheet.

splash58 · Accepted Answer · 2018-08-17 13:54:25Z

5

Use createFromFormat function

$date = DateTime::createFromFormat('d/M/Y', '12/AUG/2018');
echo $date->format('Y-m-d'); // 2018-08-12

answered Aug 17, 2018 at 13:54

splash58

26.2k3 gold badges25 silver badges35 bronze badges

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

6 Comments

Waleed Khan Over a year ago

Thanks @splash58 for quick response. If I use DateTime::createFromFormat(), It means, I should be knowing what formats are expected from excel sheet. Because data coming from excel sheet can be in different formats. So, Should I be handling all cases? Isn't there a solution like automatic format detection and parsing ?

splash58 Over a year ago

Only some fixed formats can be recognized by datetime functions. In other cases you should try all possible formats

Waleed Khan Over a year ago

how will we detect what is format of date coming in ? To pass it further on.

splash58 Over a year ago

if you know the set of formats, try them while datetime fails

Waleed Khan Over a year ago

For e.g. After failure of datetime, one format I find 12/AUG/2018, Another format I find 12.AUG.2018, So how will I decide which format to be used ?

|

Collectives™ on Stack Overflow

PHP parse date column from excel sheet (CSV)

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related