How to Change the Date and Time Format in Google Form Emails

Google Forms support both date and time fields. The time and year component can be added or removed from your date type questions based on requirements.

Date and Time Field

The date and time answers in the notification emails can be formatted based on your locale/region and are easy to understand. For instance, form users in US may prefer the MM/dd/yyyy format while respondents in India may prefer to see dates written in the dd/MM/yyyy format.

Format Date & Time in Google Forms

To apply a different format to the date and time fields in Google Form emails, launch the add-on menu and choose Manage Form Settings menu.

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 notification emails.

Change timezone and date format

Sample Date and Time Patterns

Google Forms use the Oracle date and time patterns for formatting and parsing dates. Here are some sample formats and the corresponding output that will render in the email messages.

Date and Time PatterFormatted Text Output
yyyy-MM-dd hh:mm a2020-11-19 11:34 PM
yyyy-MMM-d HH:mm:ss2020-Nov-19 23:34:49
MMMMM dd, yyyyNovember 19, 2020
EEE, d MMM yyyyThu, 19 Nov 2020
EEEEE, d MMM yyyyThursday, 19 Nov 2020
yyyy/MM/dd HH:mm:ss2020/11/19 23:34:49

Things to know

  1. If the number of pattern letters is 4 or more, the full form is used; otherwise a short or abbreviated form is used if available. For instance, MMM with display Jan but MMMMM with display January.

  2. The number of pattern letters is the minimum number of digits, and shorter numbers are zero-padded to this amount. For instance, if the date is 9th November and the format is d, the output will be 9. If the pattern is specified as dd, the output will be 09.

  3. The case of the pattern matters. M represents the month in year while lowercase m represent the minute in hour. Similar, h refers to the 12 hour clock (1-11) while H refers to the 24 hour clock (0-23).