Utilities.Formatdate结果不变

Question

这让我发疯了，但它必须很简单：-)

我有一个运行在电子表格上的Google脚本，我想输入一个包含当前日期的字符串(例如“在2016年10月06日生成@ 18:10")。

下面是我使用的测试代码和一个示例Logger.log。

我的问题是，无论实际时间如何，Utilities.Formatdate的结果总是返回相同的值。

伙计们有什么想法吗？蒂娅：-)干杯...Steve

function TEST() {

  var sheet = SpreadsheetApp.getActiveSheet();
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var cell=sheet.getRange("A1");

Logger.log(new Date());
  var nowdate = new Date();
Logger.log (nowdate);
  var nowdatestr = ("Produced at: " +Utilities.formatDate(nowdate, "GMT+10", "dd MMM YYYY @ HH:MM"));
Logger.log (nowdatestr);
//  cell.setValue(nowdatestr);
Logger.log (Utilities.formatDate(new Date(), "GMT+10", "dd MMM YYYY @ HH:MM"));
Logger.log (cell.getValues());
Logger.log(new Date());

}

日志结果：

[16-10-06 18:46:58:022 AEST] Thu Oct 06 18:46:58 GMT+10:00 2016
[16-10-06 18:46:58:022 AEST] Thu Oct 06 18:46:58 GMT+10:00 2016
[16-10-06 18:46:58:024 AEST] Produced at: 06 Oct 2016 @ 18:10
[16-10-06 18:46:58:024 AEST] 06 Oct 2016 @ 18:10
[16-10-06 18:46:58:081 AEST] [[Title]]
[16-10-06 18:46:58:082 AEST] Thu Oct 06 18:46:58 GMT+10:00 201

下面是维托塔斯和鲁本的文章。

@Vytautas:您整理的版本省略了真实日期的日志，这就显示了我遇到的问题。

因此，使用：

function TEST2() {

  var sheet = SpreadsheetApp.getActiveSheet();
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var cell=sheet.getRange("A1");

var nowdate = new Date()
var nowdatestr = ("Produced at: " + Utilities.formatDate(nowdate, 'GMT+10', 'dd MMM YYYY @ HH:MM'));
Logger.log (nowdatestr);
cell.setValue(nowdatestr);
Logger.log ("real new date and time is: " +new Date());
Logger.log (cell.getValues())
}

给出日志：

[16-10-07 12:31:57:265 AEST] Produced at: 07 Oct 2016 @ 12:10
[16-10-07 12:31:57:315 AEST] real new date and time is: Fri Oct 07 2016 12:31:57 GMT+1000 (AEST)
[16-10-07 12:31:57:448 AEST] [[Produced at: 07 Oct 2016 @ 12:10]]

@Ruben:在每个新的Date()调用之前插入Utilities.sleep(1000)没有什么区别。

也许这并不像我最初想的那样简单.：-)

++++++++++++++++++

最后的工作测试代码(谢谢Ruben)是(将HH:MM更改为HH:mm)：

function TEST2() {

  var sheet = SpreadsheetApp.getActiveSheet();
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var cell=sheet.getRange("A1");

var nowdate = new Date()
var nowdatestr = ("Produced at: " + Utilities.formatDate(nowdate, 'GMT+10', 'dd MMM YYYY @ HH:mm'));
Logger.log (nowdatestr);
cell.setValue(nowdatestr);
Logger.log ("real new date and time is: " +new Date());
Logger.log (cell.getValues())
}

谢谢!

Answer 1

简短回答

使用HH:MM代替HH:mm

解释

根据http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

• M代表月份。
• M代表分钟。

示例

function myFunction() {
  // General variables
  var stringTimeZone = 'GMT-0500';
  var stringFormat = 'dd MMM YYYY @ HH:mm'; // Use m for minutes, M for months
  // Main code
  var dateOne = new Date(); // First date instance
  var stringOne = Utilities.formatDate(dateOne, stringTimeZone , stringFormat);
  Logger.log(stringOne);
  Utilities.sleep(1000*60); // Wait one minute in order to force different date-times
  var dateTwo = new Date(); // Seconde date instance
  var stringTwo = Utilities.formatDate(dateTwo, stringTimeZone, stringFormat);
  Logger.log(stringTwo);
}

当我运行上面的脚本时，生成的日志如下：

[16-10-06 20:43:38:717 PDT] 06 Oct 2016 @ 22:43
[16-10-06 20:44:38:750 PDT] 06 Oct 2016 @ 22:44

Answer 2

这段代码正常工作。把它清理干净，这样我们就不会得到一堆什么都不告诉我们的垃圾日志。

function TEST() {

  var sheet = SpreadsheetApp.getActiveSheet();
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var cell=sheet.getRange("A1");

var nowdate = new Date()
var nowdatestr = ("Produced at: " + Utilities.formatDate(nowdate, 'GMT+10', 'dd MMM YYYY @ HH:MM'));
Logger.log (nowdatestr);
cell.setValue(nowdatestr);

Logger.log (cell.getValues())
}

​

​