質問編集履歴
8
改善
test
CHANGED
File without changes
|
test
CHANGED
@@ -130,7 +130,7 @@
|
|
130
130
|
|
131
131
|
しかし、期間の計算で今度はエラーが出る。
|
132
132
|
|
133
|
-
```Java
|
133
|
+
```JavaScript
|
134
134
|
|
135
135
|
var NOD_se_date = end_date.diff(start_date,'days');
|
136
136
|
|
7
改善
test
CHANGED
File without changes
|
test
CHANGED
@@ -130,7 +130,7 @@
|
|
130
130
|
|
131
131
|
しかし、期間の計算で今度はエラーが出る。
|
132
132
|
|
133
|
-
```
|
133
|
+
```Java Script
|
134
134
|
|
135
135
|
var NOD_se_date = end_date.diff(start_date,'days');
|
136
136
|
|
6
改善
test
CHANGED
File without changes
|
test
CHANGED
@@ -40,7 +40,7 @@
|
|
40
40
|
|
41
41
|
###コード
|
42
42
|
|
43
|
-
```
|
43
|
+
```JavaScript
|
44
44
|
|
45
45
|
//開始日の取得
|
46
46
|
|
@@ -66,7 +66,7 @@
|
|
66
66
|
|
67
67
|
試しに、日付が取得できているか以下のプログラムで確認。
|
68
68
|
|
69
|
-
```
|
69
|
+
```JavaScript
|
70
70
|
|
71
71
|
function test(){
|
72
72
|
|
@@ -114,7 +114,7 @@
|
|
114
114
|
|
115
115
|
|
116
116
|
|
117
|
-
```
|
117
|
+
```
|
118
118
|
|
119
119
|
[18-07-18 12:31:36:821 JST] 06/18
|
120
120
|
|
5
修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -74,17 +74,11 @@
|
|
74
74
|
|
75
75
|
var sheet1 = spreadsheet.getSheetByName('全チケット情報');
|
76
76
|
|
77
|
-
var sheet4 = spreadsheet.getSheetByName('リソース表');
|
78
|
-
|
79
77
|
|
80
|
-
|
81
|
-
var lastRow_k = sheet4.getLastRow();
|
82
78
|
|
83
79
|
var lastRow_i = sheet1.getLastRow();
|
84
80
|
|
85
81
|
|
86
|
-
|
87
|
-
var NOD_se_date = 0;
|
88
82
|
|
89
83
|
for(var i = lastRow_i;i>=2;i--){
|
90
84
|
|
4
誤字
test
CHANGED
File without changes
|
test
CHANGED
@@ -84,7 +84,7 @@
|
|
84
84
|
|
85
85
|
|
86
86
|
|
87
|
-
var NOD_se_ = 0;
|
87
|
+
var NOD_se_date = 0;
|
88
88
|
|
89
89
|
for(var i = lastRow_i;i>=2;i--){
|
90
90
|
|
3
修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -62,11 +62,11 @@
|
|
62
62
|
|
63
63
|
```
|
64
64
|
|
65
|
-
###エラー
|
65
|
+
###追記:エラー
|
66
66
|
|
67
67
|
試しに、日付が取得できているか以下のプログラムで確認。
|
68
68
|
|
69
|
-
```GAS
|
69
|
+
```Google Apps Script
|
70
70
|
|
71
71
|
function test(){
|
72
72
|
|
@@ -84,29 +84,29 @@
|
|
84
84
|
|
85
85
|
|
86
86
|
|
87
|
-
|
87
|
+
var NOD_se_ = 0;
|
88
88
|
|
89
|
-
|
89
|
+
for(var i = lastRow_i;i>=2;i--){
|
90
90
|
|
91
|
-
|
91
|
+
var start_date = sheet1.getRange(i,3).getValue();
|
92
92
|
|
93
|
-
|
93
|
+
var start_date = Moment.moment(start_date).format('MM/DD');
|
94
94
|
|
95
|
-
var start_date = sheet1.getRange(i,3).getValues();
|
96
95
|
|
97
|
-
var start_date = Moment.moment(start_date,'MM/DD');
|
98
96
|
|
99
|
-
|
97
|
+
var end_date = sheet1.getRange(i,4).getValue();
|
100
98
|
|
101
|
-
|
99
|
+
var end_date = Moment.moment(end_date).format('MM/DD');
|
102
100
|
|
103
|
-
var NOD_se_date = end_date.diff(start_date,'days');
|
104
101
|
|
105
|
-
Logger.log(start_date);
|
106
102
|
|
107
|
-
|
103
|
+
var NOD_se_date = end_date.diff(start_date,'days');
|
108
104
|
|
105
|
+
Logger.log(start_date);
|
106
|
+
|
109
|
-
|
107
|
+
Logger.log(end_date);
|
108
|
+
|
109
|
+
Logger.log(NOD_se_date);
|
110
110
|
|
111
111
|
}
|
112
112
|
|
@@ -116,98 +116,34 @@
|
|
116
116
|
|
117
117
|
すると、以下のログが表示。
|
118
118
|
|
119
|
-
|
119
|
+
日付の取得まではOK。
|
120
|
+
|
121
|
+
|
122
|
+
|
123
|
+
```log
|
124
|
+
|
125
|
+
[18-07-18 12:31:36:821 JST] 06/18
|
126
|
+
|
127
|
+
[18-07-18 12:31:36:821 JST] 06/20
|
128
|
+
|
129
|
+
[18-07-18 12:31:36:907 JST] 06/19
|
130
|
+
|
131
|
+
[18-07-18 12:31:36:908 JST] 06/24
|
132
|
+
|
133
|
+
[18-07-18 12:31:36:990 JST] 06/19
|
134
|
+
|
135
|
+
```
|
136
|
+
|
137
|
+
しかし、期間の計算で今度はエラーが出る。
|
120
138
|
|
121
139
|
```error
|
122
140
|
|
123
|
-
|
141
|
+
var NOD_se_date = end_date.diff(start_date,'days');
|
124
142
|
|
125
|
-
function (a) {
|
126
|
-
|
127
|
-
var c = this._isUTC ? ""UTC"" : """";
|
128
|
-
|
129
|
-
return null != a ? (this._d[""set"" + c + b](a), bb.updateOffset(this), this) : this._d[""get"" + c + b]();
|
130
|
-
|
131
|
-
}
|
132
|
-
|
133
|
-
, milliseconds=
|
134
|
-
|
135
|
-
function (a) {
|
136
|
-
|
137
|
-
var c = this._isUTC ? ""UTC"" : """";
|
138
|
-
|
139
|
-
return null != a ? (this._d[""set"" + c + b](a), bb.updateOffset(this), this) : this._d[""get"" + c + b]();
|
140
|
-
|
141
|
-
}
|
142
|
-
|
143
|
-
, _isUTC=false, dayOfYear=
|
144
|
-
|
145
|
-
function (a) {
|
146
|
-
|
147
|
-
var b = eb((bb(this).startOf(""day"") - bb(this).startOf(""year"")) / 86400000) + 1;
|
148
|
-
|
149
|
-
return null == a ? b : this.add(""d"", a - b);
|
150
|
-
|
151
|
-
}
|
152
|
-
|
153
|
-
, year=
|
154
|
-
|
155
|
-
function (a) {
|
156
|
-
|
157
|
-
var c = this._isUTC ? ""UTC"" : """";
|
158
|
-
|
159
|
-
return null != a ? (this._d[""set"" + c + b](a), bb.updateOffset(this), this) : this._d[""get"" + c + b]();
|
160
|
-
|
161
|
-
}
|
162
|
-
|
163
|
-
, weekday=
|
164
|
-
|
165
|
-
function (a) {
|
166
|
-
|
167
|
-
|
143
|
+
->TypeError: オブジェクト 06/20 で関数 diff が見つかりません。
|
168
|
-
|
169
|
-
return null == a ? b : this.add(""d"", a - b);
|
170
|
-
|
171
|
-
}
|
172
|
-
|
173
|
-
, years=
|
174
|
-
|
175
|
-
function (a) {
|
176
|
-
|
177
|
-
var c = this._isUTC ? ""UTC"" : """";
|
178
|
-
|
179
|
-
return null != a ? (this._d[""set"" + c + b](a), bb.updateOffset(this), this) : this._d[""get"" + c + b]();
|
180
|
-
|
181
|
-
}
|
182
|
-
|
183
|
-
, second=
|
184
|
-
|
185
|
-
function (a) {
|
186
|
-
|
187
|
-
var c = this._isUTC ? ""UTC"" : """";
|
188
|
-
|
189
|
-
return null != a ? (this._d[""set"" + c + b](a), bb.updateOffset(this), this) : this._d[""get"" + c + b]();
|
190
|
-
|
191
|
-
}
|
192
|
-
|
193
|
-
, invalidAt=
|
194
|
-
|
195
|
-
function () {
|
196
|
-
|
197
|
-
return this._pf.overflow;
|
198
|
-
|
199
|
-
}
|
200
|
-
|
201
|
-
, seconds=
|
202
|
-
|
203
|
-
function (a) {
|
204
|
-
|
205
|
-
var c = this._isUTC ? ""UTC"" : """";
|
206
|
-
|
207
|
-
return null != a ? (this._d[""set"" + c + b](a), bb.updateOffset(this), this) : this._d[""get"" + c + b]();
|
208
|
-
|
209
|
-
}
|
210
144
|
|
211
145
|
|
212
146
|
|
213
147
|
```
|
148
|
+
|
149
|
+
どうしたものか。。
|
2
修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -2,7 +2,9 @@
|
|
2
2
|
|
3
3
|
これを、Moment.jsを使って取得したいのですが、うまくいきません。
|
4
4
|
|
5
|
-
|
5
|
+
最終的には、日付を取得して、期間の計算を行いたいです。
|
6
|
+
|
7
|
+
|
6
8
|
|
7
9
|
|
8
10
|
|
@@ -26,6 +28,16 @@
|
|
26
28
|
|
27
29
|
|
28
30
|
|
31
|
+
例)
|
32
|
+
|
33
|
+
2018-06-23
|
34
|
+
|
35
|
+
を
|
36
|
+
|
37
|
+
6/23
|
38
|
+
|
39
|
+
と取得したい。
|
40
|
+
|
29
41
|
###コード
|
30
42
|
|
31
43
|
```Google Apps Script
|
1
修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -28,24 +28,174 @@
|
|
28
28
|
|
29
29
|
###コード
|
30
30
|
|
31
|
+
```Google Apps Script
|
32
|
+
|
33
|
+
//開始日の取得
|
34
|
+
|
35
|
+
var start_date = sheet1.getRange(i,3).getValues();
|
36
|
+
|
37
|
+
var start_date = Moment.moment(start_date,'MM/DD');
|
38
|
+
|
39
|
+
//期日の取得
|
40
|
+
|
41
|
+
var end_date = sheet1.getRange(i,4).getValues();
|
42
|
+
|
43
|
+
var end_date = Moment.moment(end_date,'MM/DD');
|
44
|
+
|
45
|
+
|
46
|
+
|
47
|
+
//期間の計算
|
48
|
+
|
49
|
+
var NOD_se_date = end_date.diff(start_date,'days');
|
50
|
+
|
51
|
+
```
|
52
|
+
|
53
|
+
###エラー
|
54
|
+
|
55
|
+
試しに、日付が取得できているか以下のプログラムで確認。
|
56
|
+
|
31
57
|
```GAS
|
32
58
|
|
33
|
-
|
59
|
+
function test(){
|
60
|
+
|
34
|
-
|
61
|
+
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
|
62
|
+
|
63
|
+
var sheet1 = spreadsheet.getSheetByName('全チケット情報');
|
64
|
+
|
65
|
+
var sheet4 = spreadsheet.getSheetByName('リソース表');
|
66
|
+
|
67
|
+
|
68
|
+
|
69
|
+
var lastRow_k = sheet4.getLastRow();
|
70
|
+
|
71
|
+
var lastRow_i = sheet1.getLastRow();
|
72
|
+
|
73
|
+
|
74
|
+
|
75
|
+
for(var k = lastRow_k;k>=2;k--){
|
76
|
+
|
77
|
+
var NOD_se_ = 0;
|
78
|
+
|
79
|
+
for(var i = lastRow_i;i>=2;i--){
|
80
|
+
|
81
|
+
var team_name = sheet1.getRange(i,2).getValues();
|
82
|
+
|
35
|
-
var start_date = sheet1.getRange(i,3).getValues();
|
83
|
+
var start_date = sheet1.getRange(i,3).getValues();
|
36
|
-
|
84
|
+
|
37
|
-
var start_date = Moment.moment(start_date,'MM/DD');
|
85
|
+
var start_date = Moment.moment(start_date,'MM/DD');
|
38
|
-
|
39
|
-
|
86
|
+
|
40
|
-
|
41
|
-
var end_date = sheet1.getRange(i,4).getValues();
|
87
|
+
var end_date = sheet1.getRange(i,4).getValues();
|
42
|
-
|
88
|
+
|
43
|
-
var end_date = Moment.moment(end_date,'MM/DD');
|
89
|
+
var end_date = Moment.moment(end_date,'MM/DD');
|
44
|
-
|
45
|
-
|
46
|
-
|
47
|
-
|
90
|
+
|
48
|
-
|
49
|
-
var NOD_se_date = end_date.diff(start_date,'days');
|
91
|
+
var NOD_se_date = end_date.diff(start_date,'days');
|
92
|
+
|
93
|
+
Logger.log(start_date);
|
94
|
+
|
95
|
+
Logger.log(end_date);
|
96
|
+
|
97
|
+
}
|
98
|
+
|
99
|
+
}
|
100
|
+
|
101
|
+
}
|
50
102
|
|
51
103
|
```
|
104
|
+
|
105
|
+
すると、以下のログが表示。
|
106
|
+
|
107
|
+
何が取得できているんか、不明。
|
108
|
+
|
109
|
+
```error
|
110
|
+
|
111
|
+
"{date=
|
112
|
+
|
113
|
+
function (a) {
|
114
|
+
|
115
|
+
var c = this._isUTC ? ""UTC"" : """";
|
116
|
+
|
117
|
+
return null != a ? (this._d[""set"" + c + b](a), bb.updateOffset(this), this) : this._d[""get"" + c + b]();
|
118
|
+
|
119
|
+
}
|
120
|
+
|
121
|
+
, milliseconds=
|
122
|
+
|
123
|
+
function (a) {
|
124
|
+
|
125
|
+
var c = this._isUTC ? ""UTC"" : """";
|
126
|
+
|
127
|
+
return null != a ? (this._d[""set"" + c + b](a), bb.updateOffset(this), this) : this._d[""get"" + c + b]();
|
128
|
+
|
129
|
+
}
|
130
|
+
|
131
|
+
, _isUTC=false, dayOfYear=
|
132
|
+
|
133
|
+
function (a) {
|
134
|
+
|
135
|
+
var b = eb((bb(this).startOf(""day"") - bb(this).startOf(""year"")) / 86400000) + 1;
|
136
|
+
|
137
|
+
return null == a ? b : this.add(""d"", a - b);
|
138
|
+
|
139
|
+
}
|
140
|
+
|
141
|
+
, year=
|
142
|
+
|
143
|
+
function (a) {
|
144
|
+
|
145
|
+
var c = this._isUTC ? ""UTC"" : """";
|
146
|
+
|
147
|
+
return null != a ? (this._d[""set"" + c + b](a), bb.updateOffset(this), this) : this._d[""get"" + c + b]();
|
148
|
+
|
149
|
+
}
|
150
|
+
|
151
|
+
, weekday=
|
152
|
+
|
153
|
+
function (a) {
|
154
|
+
|
155
|
+
var b = (this.day() + 7 - this.lang()._week.dow) % 7;
|
156
|
+
|
157
|
+
return null == a ? b : this.add(""d"", a - b);
|
158
|
+
|
159
|
+
}
|
160
|
+
|
161
|
+
, years=
|
162
|
+
|
163
|
+
function (a) {
|
164
|
+
|
165
|
+
var c = this._isUTC ? ""UTC"" : """";
|
166
|
+
|
167
|
+
return null != a ? (this._d[""set"" + c + b](a), bb.updateOffset(this), this) : this._d[""get"" + c + b]();
|
168
|
+
|
169
|
+
}
|
170
|
+
|
171
|
+
, second=
|
172
|
+
|
173
|
+
function (a) {
|
174
|
+
|
175
|
+
var c = this._isUTC ? ""UTC"" : """";
|
176
|
+
|
177
|
+
return null != a ? (this._d[""set"" + c + b](a), bb.updateOffset(this), this) : this._d[""get"" + c + b]();
|
178
|
+
|
179
|
+
}
|
180
|
+
|
181
|
+
, invalidAt=
|
182
|
+
|
183
|
+
function () {
|
184
|
+
|
185
|
+
return this._pf.overflow;
|
186
|
+
|
187
|
+
}
|
188
|
+
|
189
|
+
, seconds=
|
190
|
+
|
191
|
+
function (a) {
|
192
|
+
|
193
|
+
var c = this._isUTC ? ""UTC"" : """";
|
194
|
+
|
195
|
+
return null != a ? (this._d[""set"" + c + b](a), bb.updateOffset(this), this) : this._d[""get"" + c + b]();
|
196
|
+
|
197
|
+
}
|
198
|
+
|
199
|
+
|
200
|
+
|
201
|
+
```
|