Re: Value of a date in Numbers
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