コード.gs
function myFunction() {
const month = new Date().getMonth() + 1;// monthは0始まりなので+1
const quater = judgeQuater(month);
Logger.log([month, quater]);
}
/************************************
受け取った月からそのQuaterのStartDateと EndDateとQuaterを返す
************************************/
function judgeQuater(month) {
switch(month) {
case 7:
case 8:
case 9:
return ["07-01", "09-30", "Q1"];
case 10:
case 11:
case 12:
return ["10-01", "12-31", "Q2"];
case 1:
case 2:
case 3:
return ["01-01", "03-31", "Q3"];
case 4:
case 5:
case 6:
return ["04-01", "06-30", "Q4"];
}
}
|
ログ
[7.0, [07-01, 09-30, Q1]]
参考
Date.prototype.getMonth()
