forms - What format is required to import a date into google spreadsheet -
with of "stackoverflow" , it's users i'm using app import data google spreadsheet. problem have date question on form, , can not manage import it. if change format (in forms) text, data imports has been sent app, when change date, nothing.
i've believe i've tried usual date formats (dd/mm/yyyy, mm/dd/yyyy, yyyy/mm/dd, yyyy/dd/mm) yy above , numerical.
i know google form shows date in users format , not problem. shows correctly in spreadsheet in local format (dd/mm/yyyy).
does know format form uses send data spreadsheet, or anyway find out.
thanks in advance.
ok, after using wikipedia, , trying every different format works using format yyyy-mm-dd
Comments
Post a Comment