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.
The date and time fields in email notifications can be reformatted so that they are confirmed 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 the add-ons 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.
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.