blocks|key|2377737|text|您可以尝试使用Utilities.formatDate。此方法根据Java类中描述的规范来格式化数据。你可以访问date+and+time+patterns+here。下面是一个用法示例：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2377738|//+This+formats+the+date+as+Greenwich+Mean+Time+in+the+format
//+year-month-dateThour-minute-second.
var+formattedDate+=+Utilities.formatDate(new+Date(),+"GMT",+"yyyy-MM-dd'T'HH:mm:ss'Z'");
Logger.log(formattedDate);|code-block|syntax|javascript|2377739|请注意，使用Utilities.formatDate会产生以下效果，如本post所述|2377740|2377741|blockquote|2377742|2377743|2377744|Utilities.formatDate不会更改单元格格式；它会将其内容转换为文本。如果您要在计算中使用日期值，您不希望将其转换为text.|ordered-list-item|2377745|Utilities.formatDate需要指定时区。如果您设置了类似"GMT%2B1“的内容，并且您的国家遵守夏令时，那么几个月后很难跟踪的bug就会出现。使用setNumberFormat时，日期值与电子表格中的所有其他日期值保持一致，由其时区设置控制。|2377746|2377747|要避免出现这种情况，还可以使用setNumberFormat(numberFormat)设置日期或数字格式。Sheets+API+documentation中描述了可接受的格式模式。一个示例用法是：|2377748|var+ss+=+SpreadsheetApp.getActiveSpreadsheet();
var+sheet+=+ss.getSheets()[0];

var+cell+=+sheet.getRange("B2");
//+Always+show+3+decimal+points
cell.setNumberFormat("0.000");|2377749|entityMap|0|LINK|mutability|MUTABLE|url|https://developers.google.com/apps-script/reference/utilities/utilities#formatdatedate-timezone-format|1|https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html|2|https://webapps.stackexchange.com/a/100644|3|https://developers.google.com/apps-script/reference/spreadsheet/range#setNumberFormat(String)|4|https://developers.google.com/sheets/api/guides/formats^0|7|K|7|K|0|27|4|1|0|0|6|K|10|4|2|0|0|0|0|0|0|K|0|0|K|0|0|F|T|F|T|3|1I|O|4|0|0^^$0|@$1|2|3|4|5|6|7|1H|8|@$9|1I|A|1J|B|C]]|D|@$9|1K|A|1L|1|1M]|$9|1N|A|1O|1|1P]]|E|$]]|$1|F|3|G|5|H|7|1Q|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|1R|8|@$9|1S|A|1T|B|C]]|D|@$9|1U|A|1V|1|1W]]|E|$]]|$1|M|3|-4|5|6|7|1X|8|@]|D|@]|E|$]]|$1|N|3|-4|5|O|7|1Y|8|@]|D|@]|E|$]]|$1|P|3|-4|5|6|7|1Z|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|20|8|@]|D|@]|E|$]]|$1|R|3|S|5|T|7|21|8|@$9|22|A|23|B|C]]|D|@]|E|$]]|$1|U|3|V|5|T|7|24|8|@$9|25|A|26|B|C]]|D|@]|E|$]]|$1|W|3|-4|5|6|7|27|8|@]|D|@]|E|$]]|$1|X|3|Y|5|6|7|28|8|@$9|29|A|2A|B|C]]|D|@$9|2B|A|2C|1|2D]|$9|2E|A|2F|1|2G]]|E|$]]|$1|Z|3|10|5|H|7|2H|8|@]|D|@]|E|$I|J]]|$1|11|3|-4|5|6|7|2I|8|@]|D|@]|E|$]]]|12|$13|$5|14|15|16|E|$17|18]]|19|$5|14|15|16|E|$17|1A]]|1B|$5|14|15|16|E|$17|1C]]|1D|$5|14|15|16|E|$17|1E]]|1F|$5|14|15|16|E|$17|1G]]]]

You can try using <a href="https://developers.google.com/apps-script/reference/utilities/utilities#formatdatedate-timezone-format" rel="nofollow noreferrer"><code>Utilities.formatDate</code></a>. This method formats date according to specification described in Java SE SimpleDateFormat class. You can visit the date and time patterns <a href="https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html" rel="nofollow noreferrer">here</a>. An example of usage is:

<pre><code>// This formats the date as Greenwich Mean Time in the format
// year-month-dateThour-minute-second.
var formattedDate = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd'T'HH:mm:ss'Z'");
Logger.log(formattedDate);
</code></pre>

Do take note that using <code>Utilities.formatDate</code> has the following effects as noted in this <a href="https://webapps.stackexchange.com/a/100644">post</a>:

<blockquote>
 <ol>
 <li><code>Utilities.formatDate</code> does not change the cell format; it converts
 its content to text. If you are going to use the date value in
 computations, you don't want it to be converted to text.</li>
 <li><code>Utilities.formatDate</code> requires one to specify a timezone. If you put
 something like "GMT+1" and your country observes Daylight Saving
 Time, you can expect hard-to-track bugs to come up a few months
 later. With setNumberFormat, the date value remains consistent with
 all other date values in the spreadsheet, governed by its timezone
 setting.</li>
 </ol>
</blockquote>

To avoid these, you can also use <a href="https://developers.google.com/apps-script/reference/spreadsheet/range#setNumberFormat(String)" rel="nofollow noreferrer"><code>setNumberFormat(numberFormat)</code></a> to set the date or number format. The accepted format patterns are described in the <a href="https://developers.google.com/sheets/api/guides/formats" rel="nofollow noreferrer">Sheets API documentation</a>. And an example usage is:

<pre><code>var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];

var cell = sheet.getRange("B2");
// Always show 3 decimal points
cell.setNumberFormat("0.000");
</code></pre>

blocks|key|4750356|text|感谢所有尝试过的格式等，但随后决定添加一列，并将日期和时间分开，只将日期放入新列中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4750357|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Thanks all - tried format etc, but then just decided to add a column and split the date and time, with just the date going into a new column.

blocks|key|2377800|text|function+onEdit(e)+{
++++var+sheetName+=+'Cases+Allocation';+//name+of+the+sheet+the+script+should+work+on+
++++var+colToWatch+=+1
++++var+colToStamp+=+6+//timestamp+in+col+A
++++if+(e.range.columnStart+!==+1+%7C%7C+e.source.getActiveSheet()
++++++++.getName()+!==+sheetName+%7C%7C+e.value+==+'')+return;
++++//var+writeVal+=+e.value+!==+""+?+new+Date(),:+'';
++++e.source.getActiveSheet()
++++++++.getRange(e.range.rowStart,+colToStamp)
++++++++.setValue(new+Date(new+Date().setHours(0,0,0,0))).setNumberFormat('MM/dd/yyyy');
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2377801|下面的代码将不带时间地保存日期。您可以根据需要更改格式。该字段仍然是可以根据需要使用的日期。|unstyled|2377802|setValue(new+Date(new+Date().setHours(0,0,0,0))).setNumberFormat('MM/dd/yyyy');|2377803|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>function onEdit(e) {
 var sheetName = 'Cases Allocation'; //name of the sheet the script should work on 
 var colToWatch = 1
 var colToStamp = 6 //timestamp in col A
 if (e.range.columnStart !== 1 || e.source.getActiveSheet()
 .getName() !== sheetName || e.value == '') return;
 //var writeVal = e.value !== &quot;&quot; ? new Date(),: '';
 e.source.getActiveSheet()
 .getRange(e.range.rowStart, colToStamp)
 .setValue(new Date(new Date().setHours(0,0,0,0))).setNumberFormat('MM/dd/yyyy');
}
</code></pre>
The below code will save the date without time. You can change the format as required. The field remains a date which can be used as required.
<pre><code>setValue(new Date(new Date().setHours(0,0,0,0))).setNumberFormat('MM/dd/yyyy');
</code></pre>

Using the code below, the google sheet enters the Date in column 6 when a cell in column 1 is edited. It also includes the timestamp.

How can this code be altered so that just the date (day-month-year) is entered? This would allow searches by date on the sheet.

<pre><code> function onEdit(e) {
 var sheetName = 'Cases Allocation'; //name of the sheet the script should work on 
 var colToWatch = 1
 var colToStamp = 6 //timestamp in col A
 if (e.range.columnStart !== 1 || e.source.getActiveSheet()
 .getName() !== sheetName || e.value == '') return;
 var writeVal = e.value !== "" ? new Date(),: '';
 e.source.getActiveSheet()
 .getRange(e.range.rowStart, colToStamp)
 .setValue(writeVal);
}
</code></pre>

Inputting Date without time

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

使用下面的代码，当编辑第一列中的单元格时，google工作表在第六列中输入日期。它还包括时间戳。如何修改此代码，以便只输入日期(日-月-年)？这将允许在工作表上按日期进行搜索。  function onEdit(e) {    var sheetName = 'Cases Allocation'; //name of ...

问输入不带时间的日期
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问输入不带时间的日期EN