将日期导入Google电子表格所需的格式 [英] What format is required to import a date into google spreadsheet

问题描述

在stackoverflow的帮助下，我使用应用程序将数据导入Google电子表格。问题是我在表单上有日期问题，无法管理导入它。如果我将格式（在表单中）更改为文本，数据导入是从应用程序发送的，但是当我将其更改回日期时，则无。

我相信我已经尝试了所有常用的日期格式（日/月/年，年/月/日，年/月/日，年/月/年）以及上述日期和数值。

我知道Google表单以用户格式显示日期，这不是问题。它以我的本地格式（dd / mm / yyyy）在电子表格中正确显示。

有谁知道表单用于将数据发送到电子表格的格式，或者反正找出来。

在此先感谢。

解决方案

好吧，在使用维基百科后，尝试使用格式为yyyy-mm-dd的每种不同格式。

With the help of "stackoverflow" and it's users I'm using an app to import data into a Google spreadsheet. The problem is I have a date question on the form, and can not manage to import it. If I change the format (in the forms) to text, the data imports as it has been sent from the app, but when I change it back to date, nothing.

I've believe I've tried all the usual date formats (dd/mm/yyyy, mm/dd/yyyy, yyyy/mm/dd, yyyy/dd/mm) as well as yy for the above and also numerical.

I know that the Google form shows the date in the users format and that is not a problem. It shows up correctly in the spreadsheet in my local format (dd/mm/yyyy).

Does anyone know what format the form uses to send the data to the spreadsheet, or anyway to find out.

Thanks in advance.

解决方案

Ok, after using wikipedia, and trying every different format it works by using the format yyyy-mm-dd

这篇关于将日期导入Google电子表格所需的格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！