teratail header banner
teratail header banner
質問するログイン新規登録

回答編集履歴

4

修正

2021/06/20 08:14

投稿

退会済みユーザー
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

修正

2021/06/20 08:14

投稿

退会済みユーザー
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

修正

2021/06/20 02:40

投稿

退会済みユーザー
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 weeks = ["日","月","火","水","木","金","土"];
14
+ var = ["月","火","水","木","金","土","日"];
15
15
  var weekstr = weeks[value.getDay()];
16
16
  value = ymd + "(" + weekstr + ")";
17
17
  }

1

修正

2021/06/20 02:38

投稿

退会済みユーザー
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(date,"Asia/Tokyo","yyyy/MM/dd");
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 + ")";