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
