使用Google Script检查一个日期是否大于另一个日期 [英] Checking if one date is greater than the other using Google Script

问题描述

我正在尝试使用Google脚本检查一个日期是否大于另一个日期. 我正在从电子表格中提取日期并将其格式化.然后我对照今天的日期进行检查.如果今天的日期小于提取的日期，则必须完成一些功能.据我所知.

I am trying to check if one date is greater than another date using google script. I am extracting a date from the spreadsheet and formatting it. Then I check it against today's date. If today's date is less than the extracted date, some functionality has to be done.This is as far as I have got.

var ss = SpreadsheetApp.getActiveSpreadsheet(); 
var sheet1 = ss.getSheetByName("Sheet1"); //activating a particular sheet
var data = sheet1.getRange(2, 1, sheet1.getLastRow(), 100).getValues();

for (var row = 0; row < data.length; row++) {
    var todayDate = Utilities.formatDate(new Date(), "GMT", "MM/dd/yyyy");
    var dueDate = new Date(data[row][17]);
    //Logger.log("Due: "+dueDate);
    var nRow = row+1;
    dueDate.setDate(dueDate.getDate()+1);
    var curDate=Utilities.formatDate(dueDate, "GMT", "MM/dd/yyyy");
    //Logger.log("Current: "+curDate);

    if(curDate>todayDate){
        Logger.log("Today: "+todayDate);
        Logger.log("Current: "+curDate);
        Logger.log("In");
    }
 }

我能够记录这些值，但是if()语句似乎不起作用.我在哪里弄错了?

I am able to log the values but the if() statement does not seem to work. Where have I gone wrong?

推荐答案

问题已解决.解决方案是:

Problem got solved. Solution was:

if(curDate.valueOf()>todayDate.valueOf()){}

它现在正在工作.

这篇关于使用Google Script检查一个日期是否大于另一个日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！