Re: Numbers dates and AppleScript
Re: Numbers dates and AppleScript
- Subject: Re: Numbers dates and AppleScript
- From: Deivy Petrescu <email@hidden>
- Date: Fri, 27 Apr 2018 10:08:14 -0400
> On Apr 21, 2018, at 21:56 , Shane Stanley <email@hidden> wrote:
>
> On 22 Apr 2018, at 3:02 am, Deivy Petrescu <email@hidden> wrote:
>>
>> since the spreadsheet is created by AS I did not set the format
>
> Can you create it from a template that has the format set? My (admittedly
> very limited) experience is that relying on automatic formatting is
> unreliable.
>
> --
> Shane Stanley <email@hidden>
> <www.macosxautomation.com/applescript/apps/>, <latenightsw.com>
>
Shane,
Thank you for the suggestion.
I got some private email about Numbers time and GMT.
But after some trials here, I believe that the problem with Numbers, at least
in the US has something to do with daylight savings time.
Even setting the time format for all dates, when I read the date from Numbers
using AS, it turns out that the value of the cell its moved back an hour during
the DLST period.
The formatted value shows the correct date.
For example:
——> Sunday, January 21, 2018 at 23:00:00 01/22/2018 <——
however,
——> Monday, March 19, 2018 at 00:00:00 03/19/2018 <——
Where the first column is the value and the second the formatted value.
I will have to set the format of the cell programmatically if I can, and read
the formatted value.
Again, thanks!
Deivy Petrescu
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