Space Level - Date & Time
What does Date & Time mean?
Setting the Date & Time at the Space Level sets the default Date & Time used for all Excellentables under this Space. The Date & Time selection will change how any Date & Time is shown to the selected way within the Excellentable.
How to get to it?
- Follow instructions in How to get to Space Settings
- Click drop down next to Date & Time.
- You will have the ability to search for the Date & Time you'd like to use by either using the search box or scrolling.
What Date & Time formats are available?
Example | Token Code |
2021-01-05 | yyyy-mm-dd |
01-05-2021 | mm-dd-yyyy |
1/5/21 | m/d/yy |
01/05/21 | mm/dd/yy |
1/5 | m/d |
5-Jan | d-mmm |
5-Jan-2021 | d-mmm-yyyy |
January 5, 2021 | mmmm d, yyyy |
Jan 5, 2021 | mmm d, yyyy |
January 5 | mmmm d |
1:30:30 PM | h:mm:ss am/pm |
1:30 PM | h:mm am/pm |
13:30:30 | h:mm:ss |
13:30 | h:mm |
Tuesday, January 5, 2021 | dddd, mmmm d, yyyy |
Tuesday, January 5, 2021 at 1:30:30 PM | dddd, mmmm d, yyyy at h:mm:ss am/pm |
Tuesday, January 5, 2021, 1:30:30 PM | dddd, mmmm d, yyyy, h:mm:ss am/pm |
Token Code | Description |
h | Hour of the day. Switches between 12 and 24 hour format depending on whether an am/pm indicator is present in the string. |
m | If the previous non-literal token was hours or the subsequent one is seconds, then it represents minutes in the hour (no leading 0). Otherwise, it represents the month of the year as a number (no leading 0). |
mm | As above, but with a leading 0 for both cases. |
mmm | Three letter month abbreviation (e.g., "Feb"). |
mmmm | Full month name. mmmmmm+ also matches this. |
s | Seconds in the minute without a leading 0. |
ss | Seconds in the minute with a leading 0. |
d | Day of the month, no leading 0 for numbers less than 10. |
dd | Day of the month, with a leading 0 for numbers less than 10. |
ddd | Day of the week, three letter abbreviation (e.g., "Mon"). |
dddd | Day of the week, full name. |
y | 2-digit year. |
yyyy | 4-digit year. |
am/pm | As above, but displays "AM" or "PM" instead and is always capitalized. |