This content is likely not relevant anymore. Try searching or browse recent questions.
How do you change the date format in Google forms? 2 Recommended Answers 22 Replies 323 Upvotes
How do I change the format of the date in a google form. Default is MM/DD/YY but I want it DD/MM/YY
Recommended Answer Recommended Answers (2)
Recommended Answer
The date format for all Google documents is linked to the Language setting of your profile, go to your Google Account, select Data and Personalisation, then scroll down and click Language (under General Preferences for the Web), changing it from US English to English Australian changes the date format. More precisely: click the edit symbol (pencil) and type in your Language - tying English gives all the subversions of English. There are many other languages there too. recommended this
marked this as an answer
Recommended Answer
Hello Renan,
As Brock previously stated, the date default format is set by the selected language settings. Forms does not have a method to override the setting.
If you would like additional features or options, you should provide feedback to Google. Go to the edit form view, in the bottom right corner is a "?" icon for "Report a problem". You can share requests and ideas here. The Google product team does review this feedback. The more request for a feature, the more likely for it to be added.
cheers,
GregE
GregE
Product Expert volunteer
recommended this
marked this as an answer
All Replies (22)
Recommended Answer
recommended this
marked this as an answer
Recommended Answer
This is the first search in google, and it doesn't work anymore.
recommended this
marked this as an answer
Recommended Answer
The above link send us to google forms notification. It does not show how to change the date format in google forms.
Best Regards,
Julio Borges
Rio de Janeiro - Brazil
Best Regards,
Julio Borges
Rio de Janeiro - Brazil
recommended this
marked this as an answer
Recommended Answer
The date format for all Google documents is linked to the Language setting of your profile, go to your Google Account, select Data and Personalisation, then scroll down and click Language (under General Preferences for the Web), changing it from US English to English Australian changes the date format. More precisely: click the edit symbol (pencil) and type in your Language - tying English gives all the subversions of English. There are many other languages there too. recommended this
marked this as an answer
Recommended Answer
UKPaul, thank you. Very informative. Two questions:
1) I would like to force date/time format for both questionnaire and the response. More specifically, I want to force 24h time format for the response, and I want to have this response to be sent to an email address. The response email would show something like "The result is: 15:35:59". And I can almost achieve this. Using the Google Forms Extension "Email Notifications for Google Forms", the response for "Date incl. Time" can be forced to HH:mm:ss. However, that extension doesn't support only "Time" (it supports only Date incl. Time) for the localization part. But that extension is good in that it sends the actual responses in the reponse email (as opposed to sending a link to responses like Google Forms would do without the extension). Is there a way to force the Time to be in 24h format for the response (as opposed to the question)?
2) Are you able to add a new question to your "Example Date and Time Formats" form, a Time Field which would force 24h time format regardless of browser?
recommended this
marked this as an answer
This question is locked and replying has been disabled.
Link to post
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
This reply is no longer available.
Badges
Some community members might have badges that indicate their identity or level of participation in a community.
