On Thursday 02 February 2006 01:38 pm, Ray Hauge wrote:
Hello all,
I have a script that takes a CSV file in as data and does some updates to
the DB accordingly. Some of those values are dates. When I save the
spreadsheet in Open Office to a CSV file, the dates are saved as the
internal date format of Open Office. I need to figure out a way to convert
that number into an actual date
I know that this might not necessarily be a PHP question, but I was hoping
to be able to solve this problem with PHP. I checked, and MS Excel is one
day off from Open Office on the internal date values, which throws a huge
wrench in my program, since not everyone has Excel here.
So, there are two possible solutions to my problem. Find a way to make the
date the text it is supposed to represent and save that in the CSV file, or
use PHP to calculate the correct date.
On a side note, I did figure out a function to be able to handle this in
the spreadsheet, but the users will ask questions even if I show them time
and time again how to do it.
=CONCATENATE(MONTH(D2); /; DAY(D2); /; YEAR(D2))
Just trying to find an easier solution :)
Thanks!
--
Ray Hauge
Programmer/Systems Administrator
American Student Loan Services
http://www.americanstudentloan.com
1.800.575.1099
Okay, I finally found the answer to my question after some more searching:
date(d.m.Y - H:i:s,(($value - 25569)*86400)-7200);
This is for Excel, but is off a day if you are using Open Office. I think
that will just have to be documented and people limited to one program,
unless anyone can think of a way to distinguish one CSV file from another.
--
Ray Hauge
Programmer/Systems Administrator
American Student Loan Services
http://www.americanstudentloan.com
1.800.575.1099
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php