• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Value of a date in Numbers
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Value of a date in Numbers


  • Subject: Re: Value of a date in Numbers
  • From: email@hidden
  • Date: Tue, 3 Feb 2009 07:40:34 -0800

From the numbers and the standard additions dictionary:

AppleScript knows nothing of time zones.

Yet, the current date osax command returns the date using the time zone specified set in the mac's preferences.

So the date class is time zone neutral but current date commands knows about time zones.

This may be worth a bug/feature request for numbers.

ES

On Feb 2, 2009, at 6:41 PM, Michelle Steiner wrote:

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.

-- Michelle

--
Never play strip Tarot.

_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (applescript- email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users


This email sent to email@hidden

Coach Ed Stockly email@hidden email@hidden Home: (818) 248-9343 Cell: (818) 929-9335 Work: (213)237-6880





_______________________________________________
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
  • Follow-Ups:
    • Re: Value of a date in Numbers
      • From: KOENIG Yvan <email@hidden>
References: 
 >Value of a date in Numbers (From: Michelle Steiner <email@hidden>)

  • Prev by Date: Re: Value of a date in Numbers
  • Next by Date: Re: Value of a date in Numbers
  • Previous by thread: Re: Value of a date in Numbers
  • Next by thread: Re: Value of a date in Numbers
  • Index(es):
    • Date
    • Thread