How to Change the Date and Time Format in Google Forms Email

Google Forms support both the date and time fields. The time component and year component can be added / hidden inside the date field based on requirements.

date-time-form-fields.png

The date and time fields in email notifications can be reformatted so that they are confirm to your locale / region and are easy to understand. For instance, you could US users may prefer mm/dd/yyyy format while Europe (UK) users may prefer dd/mm/yyyy format.

Reformat Date & Time in Google Forms

To reformat date and times in Google Forms, go to addons menu, choose Email Notifications for Google Forms > Manage Form Settings. Here choose “Edit Format” under “Reformat Date & Time” section.

You can now change the default timezone of your Google Form and also specify the exact date and time format that should be used for outputting date and time type questions in email notifications.

date-time-format.png

Google Forms use the Oracle date and time patters for formatting and parsing dates. Here are some sample formats and the corresponding outut.

Date Format Sample Output
YYYY-MM-d hh:mm a 2016-11-28 06:30 PM
YY-MMM-d HH:mm:ss 2016-Nov-28 18:30:22
EEE, d MMM yyyy Wed, 4 Jul 2016
YYYY/MM/dd HH:mm:ss 2016/11/29 12:08:56

“M” represents the month in year. If you say “MM”, it is interpreted as the month number while “MMM” will display the month’s short name. You can say “MMMM” to output the full name of the month.

Similarly, “E” is day name of the week while “a” is the AM / PM marker. You can check the date time formats documentation.