Re: Leopard Date Bugs [don't overlook the japanese part]
Re: Leopard Date Bugs [don't overlook the japanese part]
- Subject: Re: Leopard Date Bugs [don't overlook the japanese part]
- From: KOENIG Yvan <email@hidden>
- Date: Sat, 17 Nov 2007 13:58:28 +0100
Le 17 nov. 07 à 00:29:41, Stockly, Ed a écrit :
Thanks for the interest here. But some of you are missing part #2
of my
original post. This involves not dates from 1000 to 1099 but
rather possibly
all dates when using Japanese region or Japanese calendar and
possibly other
International settings.
Yes, I overlooked that part as well.
The dates were in an Excel spreadsheet entered as: "11/11/2007" and
formatted to display as date "Sunday, November 11, 2007" but instead
displayed "Sunday, November 5, 2007".
It is very possible the mac that generated the problem has an
international
version of Leopard installed, but I won't know until Monday. : (
I met this kind of anomaly with Numbers under Tiger as well as under
Leopard.
Type thi simple formula:
=EDATE(DATE(1904,1,1), 0.5)
the displaid result is
1 janv. 04 which is not foolish.
From the Inspector of cells, select the format "long date" and the
display becomes:
vendredi 1 janvier 1904 00:00:00
which is always OK.
Now, select the same format "long date" from the tool bar, the
display becomes:
vendredi 1 janvier 1903 00:00:00
which is a bit odd ;-)
I'm not sure that it is related to the oddity described in this thread.
Yvan KOENIG
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden