回答編集履歴
4
修正
answer
CHANGED
@@ -11,7 +11,7 @@
|
|
11
11
|
var value = range.getCell(row, i).getValue(); //最終行
|
12
12
|
if(item == "タイムスタンプ" || item == "出勤日" || item == "退勤日"){
|
13
13
|
var ymd = Utilities.formatDate(value,"Asia/Tokyo","yyyy/MM/dd");
|
14
|
-
var = ["日","月","火","水","木","金","土"];
|
14
|
+
var weeks = ["日","月","火","水","木","金","土"];
|
15
15
|
var weekstr = weeks[value.getDay()];
|
16
16
|
value = ymd + "(" + weekstr + ")";
|
17
17
|
}
|
3
修正
answer
CHANGED
@@ -11,7 +11,7 @@
|
|
11
11
|
var value = range.getCell(row, i).getValue(); //最終行
|
12
12
|
if(item == "タイムスタンプ" || item == "出勤日" || item == "退勤日"){
|
13
13
|
var ymd = Utilities.formatDate(value,"Asia/Tokyo","yyyy/MM/dd");
|
14
|
-
var = ["月","火","水","木","金","土"
|
14
|
+
var = ["日","月","火","水","木","金","土"];
|
15
15
|
var weekstr = weeks[value.getDay()];
|
16
16
|
value = ymd + "(" + weekstr + ")";
|
17
17
|
}
|
2
修正
answer
CHANGED
@@ -11,7 +11,7 @@
|
|
11
11
|
var value = range.getCell(row, i).getValue(); //最終行
|
12
12
|
if(item == "タイムスタンプ" || item == "出勤日" || item == "退勤日"){
|
13
13
|
var ymd = Utilities.formatDate(value,"Asia/Tokyo","yyyy/MM/dd");
|
14
|
-
var
|
14
|
+
var = ["月","火","水","木","金","土","日"];
|
15
15
|
var weekstr = weeks[value.getDay()];
|
16
16
|
value = ymd + "(" + weekstr + ")";
|
17
17
|
}
|
1
修正
answer
CHANGED
@@ -10,7 +10,7 @@
|
|
10
10
|
var item = range.getCell(1, i).getValue(); //1行目
|
11
11
|
var value = range.getCell(row, i).getValue(); //最終行
|
12
12
|
if(item == "タイムスタンプ" || item == "出勤日" || item == "退勤日"){
|
13
|
-
var ymd = Utilities.formatDate(
|
13
|
+
var ymd = Utilities.formatDate(value,"Asia/Tokyo","yyyy/MM/dd");
|
14
14
|
var weeks = ["日","月","火","水","木","金","土"];
|
15
15
|
var weekstr = weeks[value.getDay()];
|
16
16
|
value = ymd + "(" + weekstr + ")";
|