将日期添加到日期 - Google脚本 [英] Adding Days to a Date - Google Script
本文介绍了将日期添加到日期 - Google脚本的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
for(var)我不知道如何在Google表格中添加日期。 i = 0; i< data.length; ++ i){
var row = data [i];
var car = row [1];
var date = row [2]; ((car ==Car1)||(car ==Car2)){
var newDay = new Date(date + 154);
if
Logger.log(newDay);
}
我试过使用 new Date(date。 add({days:154}));
但是会抛出一个关于在对象中找不到 add()
的错误。 b
$ b
我认为这可能是格式问题,表格格式为 7/26/2014
。
解决方案
可能有很多方法可以做到这一点,这里有2个
- 知道JavaScript Date的本地值是毫秒,您可以将
n
次数3600000 * 24毫秒添加到此本机值,n
是天数。
- 或者您可以获取日期值,将
n
添加到此值并重建那个日期。要获得一天,只需使用getDate()
。请参阅JS日期的文档此处。
以下是一个简单的演示函数,它使用两种方法并在记录器中显示结果:
function myFunction(){
var data = SpreadsheetApp.getActive()。getActiveSheet()。getDataRange()。getValues();
for(var i = 0; i< data.length; ++ i){
var row = data [i];
var car = row [1];
var date = new Date(row [2]); //使表单值为日期对象
Logger.log('original value ='+ date);
Logger.log('method 1:'+ new Date(date.getTime()+ 5 * 3600000 * 24));
Logger.log('method 2:'+ new Date(date.setDate(date.getDate()+ 5)));
}
}
I can't figure out how to add days to a date from Google Sheets in Google Script.
for (var i = 0; i < data.length; ++i) {
var row = data[i];
var car = row[1];
var date = row[2];
if ((car == "Car1") || (car == "Car2")) {
var newDay = new Date(date + 154);
Logger.log(newDay);
}
I've tried using new Date(date.add({days: 154}));
But that throws an error about not finding add()
in the object.
I thought it may be a formatting issue, in Sheets the format is 7/26/2014
.
解决方案
There are probably many ways to do that, here are 2 of them
- Knowing that native value of JavaScript Date are milliseconds, you can add
n
times 3600000*24 milliseconds to this native value,n
being the number of days. - or you can get the day value, add
n
to this value and rebuild the date with that. To get the day simply usegetDate()
. See doc on JS date here.
Below is a simple demo function that uses both methods and shows results in the logger :
function myFunction() {
var data = SpreadsheetApp.getActive().getActiveSheet().getDataRange().getValues();
for (var i = 0; i < data.length; ++i) {
var row = data[i];
var car = row[1];
var date = new Date(row[2]); // make the sheet value a date object
Logger.log('original value = '+date);
Logger.log('method 1 : '+new Date(date.getTime()+5*3600000*24));
Logger.log('method 2 : '+new Date(date.setDate(date.getDate()+5)));
}
}
这篇关于将日期添加到日期 - Google脚本的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文