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