Numbers dates and AppleScript
Numbers dates and AppleScript
- Subject: Numbers dates and AppleScript
- From: Deivy Petrescu <email@hidden>
- Date: Fri, 20 Apr 2018 13:34:57 -0400
Firstly, this time I checked, and it is actually Numbers….
Well, this is the issue:
I have a script that creates a spreadsheet to manage my classes.
It has grades and attendance.
To create the attendance, I put the weekdays of the classes and the first day
of class.
The spreadsheet is created with all the dates that we have classes.
I have a second script the reads all the information for each student and
creates a webpage with students grades, attendance and last class attended.
When I look at the dates on my attendance sheet they all look right.
For example, assuming a once a week class, I see the following as the columns
headers:
Feb 03, Feb 10, Feb 17, Feb 24, etc
However, as I check the dates, it would be for example Feb 03, 2018, Feb 10
2018, Feb 01 2017, Feb 24 2018, etc.
See Feb 01 2017? It looks right in the spreadsheet but it is actually wrong.
I noticed because when I was looking at last class attended, it was in the far
away past.
Then I fixed, manually all the wrong dates, run the script to create a webpage
again and then something weird happened, say the last class attended was say
Monday April 16 2018, it would show as Sunday April 15 2018.
So I go back to the sheet and it correctly shows Monday April 16 2018 as the
last class attended.
I think this has been happening for a long time, because I have another script
that reads the spread sheet and fills the information to a webpage.
It turns out that I always had to do a 1 day correction, however, then I
thought the problem was with the server software.
I can’t decide if this is a problem with Numbers or AppleScript & Numbers.
I’d appreciate if any one could confirm this.
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