Re: Daylight Savings Time
Re: Daylight Savings Time
- Subject: Re: Daylight Savings Time
- From: "Mark J. Reed" <email@hidden>
- Date: Sat, 21 Aug 2010 09:22:00 -0400
Given that Excel date values are unanchored in space (no time zone
information), and AFAICT AppleScript 'date "string"' constructor
ignores time zones except GMT in the string, there's an hour out of
the year that you simply can't refer to at all:
set nearFallBack to date "Sunday, November 7, 2010 1:30:00 AM"
strftime nearFallBack into "%FT%TZ" with GMT
That returns 05:30:00Z, but that's only accurate for the first
occurrence of 1:30 on that date (EDT). I don't see any way using date
"string" to refer to the second 1:30 (EST). And an Excel date has no
more information - 40489.0625 is just a numeric representation of the
idea "Sunday, November 7, 2010 at 1:30 AM". Unless you use time zone
information out of band (in a neighboring cell in the spreadsheet,
maybe), you can't distinguish the hour before and after falling back.
On Fri, Aug 20, 2010 at 10:01 PM, Emmanuel LEVY <email@hidden> wrote:
> On Aug 21, 2010, at 3:51 AM, Gil Dawson wrote:
>
>> Thank you, Unix, for working this out, and thank you, Satimage, for making
>> it available, and thank you, Emmanuel, for pointing it out
>
> also, thank you, the archive, for making past information available, and
> thank you, Gil, for such a kind and positive vision.
>
> Emmanuel
>
> _______________________________________________
> 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
>
--
Mark J. Reed <email@hidden>
_______________________________________________
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