Hi, I'm having a problem with using PHPExcel to convert from .xls and .xlsx to csv, which is that dates often end up being written like 12/10/09 or something equally ambigious. This then causes problems when reading the CSV file as the program reading it
isn't able to determine exactly what date it is.
So I'm wondering, is there a (preferably easy) way of setting what format is used for dates when writing CSV files? I'd really like all dates to be written in ISO-format YYYY-MM-DD in the CSV file.
I suppose iterating over the entire file and setting the cell to text, converting the value from Excel's timestamp format to a Unix timestamp and then setting the cell's value manually using date() could do the trick, but is there perhaps an easier way?
And my apologies if this has been answered somewhere else, I was unable to find something that was quite the same as this.