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

回答編集履歴

3

2019/06/30 16:16

投稿

papinianus
papinianus

スコア12705

answer CHANGED
@@ -6,7 +6,7 @@
6
6
  const target = new Date(Val.getFullYear(), Val.getMonth(), Val.getDate())
7
7
  const now = new Date()
8
8
  const today = new Date(now.getFullYear(),now.getMonth(),now.getDate())
9
- return (target - now)/60*60*24
9
+ return Math.floor((target - now)/(60*60*24*1000)) + 1
10
10
 
11
11
  }
12
12
  ```

2

D

2019/06/30 16:16

投稿

papinianus
papinianus

スコア12705

answer CHANGED
@@ -3,7 +3,7 @@
3
3
  function q196999() {
4
4
  const sheet = SpreadsheetApp.getActiveSheet()
5
5
  const Val = sheet.getRange("A1").getValue()
6
- const target = new Date(Val.getFullYear(), Val.getMonth(), Val.getDaye())
6
+ const target = new Date(Val.getFullYear(), Val.getMonth(), Val.getDate())
7
7
  const now = new Date()
8
8
  const today = new Date(now.getFullYear(),now.getMonth(),now.getDate())
9
9
  return (target - now)/60*60*24

1

S

2019/06/25 15:23

投稿

papinianus
papinianus

スコア12705

answer CHANGED
@@ -4,7 +4,7 @@
4
4
  const sheet = SpreadsheetApp.getActiveSheet()
5
5
  const Val = sheet.getRange("A1").getValue()
6
6
  const target = new Date(Val.getFullYear(), Val.getMonth(), Val.getDaye())
7
- Const now = new Date()
7
+ const now = new Date()
8
8
  const today = new Date(now.getFullYear(),now.getMonth(),now.getDate())
9
9
  return (target - now)/60*60*24
10
10