Dynamic values let you insert values like date and time at runtime. Take advantage of this feature and do not provide them in a spreadsheet.
KEEP IN MIND: Dynamic values are counted for the locale and time zone you select in spreadsheet. For example for locale Thailand add-on inserts year 2563 instead of 2020.
Inserts current year as four digit number. Examples: 2020, 2563 (Thailand)
Inserts current month number without leading zero. Examples: 2, 10
When option Append zero is selected resulting number has always two digits. Examples: 02, 10
Inserts name of current month for selected locale. Examples: May (English), มิถุนายน (Thai)
You can select capitalization where only the first letter is capitalized (May), all letters are uppercase (MAY) or lowercase (may).
Inserts current day number without leading zero. Examples: 2, 29
When option Append zero is selected resulting number has always two digits. Examples: 02, 29
Inserts name of current day for selected locale. Examples: Monday (English), วันจันทร์ (Thai)
You can select capitalization where only the first letter is capitalized (Monday), all letters are uppercase (MONDAY) or lowercase (monday).
Insert current hour. 12 hour clock format. Examples: 1, 11, 3
When option Append zero is selected resulting number has always two digits. Examples: 01, 11, 03
Insert current hour. 24 hour clock format. Examples: 1, 11, 15
When option Append zero is selected resulting number has always two digits. Examples: 01, 11, 15
Inserts current minute. Example: 9, 59
When option Append zero is selected resulting number has always two digits. Examples: 09, 59
Inserts current second. Example: 9, 59
When option Append zero is selected resulting number has always two digits. Examples: 09, 59
Inserts milliseconds since 1970. Example: 1589313710561
Inserts AM/PM indicator. Example: AM
You can select capitalization where only the first letter is capitalized (Am), all letters are uppercase (AM) or lowercase (am).
Inserts universally unique identifier (version 4). Example: a92e0180-6f00-4d00-85b9-4c45ce02a8e6
You can select capitalization where only the first letter is capitalized, all letters are uppercase or lowercase.
Inserts email address of the current user. Example: john.doe@acme.org
You can select capitalization where only the first letter is capitalized, all letters are uppercase or lowercase.
With this approach where each part of date or time is independent from each other you can construct any pattern you need. For example, let's have following tags in a template:
With mappings:
You can achieve any date format you want in the template just surround the tags with characters you want. Let's say right now is May 12 2020 08:00:00 and use some common date patterns: