Apple

On Feb 4, 2009, at 8:32 AM, Luther Fuller wrote:

Now, back to the original problem: Do dates stored in Numbers follow this standard?

Numbers apparently treats the displayed time in a cell as being GMT, but reports it to Applescript as local time. When changing the time zone in System Preferences, the date/time displayed in Numbers does not change, but the date/time it reports to Applescript does change.

and: Do dates stored in iCal follow this standard?

The Advanced panel of Numbers' preferences has a checkbox item, "Turn on Time Zone Support"; here is what "help" has to say about it:

To change the time zone for an event:

Choose iCal > Preferences, click Advanced, and select the “Turn on time zone support” checkbox.

In the main calendar view, double-click the event or select it and click the Info button in the bottom-right corner of the iCal window.

To change the event’s time zone, choose a time zone from the pop-up menu in the event editor.

To make the event appear at the same time no matter what time zone the main calendar view is in, choose Floating.

To choose a location that isn’t listed in the menu, choose Other. Click the approximate location for your time zone on the map, and then choose a city from the pop-up menu that appears.

-- Michelle

"I never told my religion, nor scrutinized that of another. I never attempted to make a convert, or wished to change another's creed. I have judged of other's religion by their lives, for it is from our lives, and not from our words, that our religion must be read."

~Thomas Jefferson

References:
	>Value of a date in Numbers (From: Michelle Steiner <email@hidden>)
	>Re: Value of a date in Numbers (From: Luther Fuller <email@hidden>)
	>Re: Value of a date in Numbers (From: Michelle Steiner <email@hidden>)
	>Re: Value of a date in Numbers (From: Luther Fuller <email@hidden>)
	>Re: Value of a date in Numbers (From: "Mark J. Reed" <email@hidden>)
	>Re: Value of a date in Numbers (From: Luther Fuller <email@hidden>)