• 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: "Stockly, Ed" <email@hidden>
  • Date: Tue, 03 Feb 2009 14:45:01 -0800
  • Thread-topic: Value of a date in Numbers

>> When it is 18h in France, AppleScript returns 18 in current date

> I wonder, shouldn't you use "current date - time to GMT" rather than
> "current date" alone?

Just to clarify,

(current date) returns the time in your current time zone.

(time to GMT) returns the offset in seconds from your current timezone to
Greenwich Mean Time (GMT)

((time to GMT) / 60 / 60 ) returns the offset in hours

In California, we're 8 hours behind GMT so that value would be: - 8 hours.
If France they are 1 hour ahead of GMT to that value would be: 1 hour.

(current date) - (time to GMT) would return the time in Greenwich compared
to the date and time from your's mac's selected time zone.

If you pull a date/time value from a Numbers cell that gives you time in
GMT, then you would want to add (time to GMT)


Noon in Greenwich + (1 hour) = 1 pm-- in France

Noon in Greenwich + (-8 hours) = 4 am-- in Sunny California.

So the solution would be:

numbersTimeValue + (time to GMT) = [localized time value]

HTH,

ES


 _______________________________________________
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

  • 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: path to a script
  • Index(es):
    • Date
    • Thread