Re: Value of a date in Numbers
Re: Value of a date in Numbers
- Subject: Re: Value of a date in Numbers
- From: KOENIG Yvan <email@hidden>
- Date: Tue, 3 Feb 2009 08:51:30 +0100
Le 3 févr. 2009 à 03:41:26, Michelle Steiner a écrit :
value of a cell, when the cell is formated as a time (or date-time)
returns Greenwich Mean Time instead of the local date displayed in
the spreadsheet.
I didn't discover this "feature"; I learned of it from someone
else. But is it a bug or is it as designed?
It does mean that when using that time in other applications, such
as creating an event in iCal, you have to subtract "time to GMT"
from it to get the correct time in the event.
I already reported that to Apple.
When I want to compare a date stored in Numers and an AppleScript's
date, I set the value of a cell in a temporary table to (=
theAscriptDate) and grab the value of this cell from the table.
Given that I have coherent dates to compare.
An example is available on my idisk:
<http://idisk.me.com/koenigyvan-Public?view=web>
in
For_iWork:iWork '09:for_Numbers09:dateTimeAndDuration.zip
Yvan KOENIG (from FRANCE mardi 3 février 2009 08:51:27) _______________________________________________
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