Instance Level - Date & Time

What does Date & Time mean?

Setting the Date & Time at the Instance Level sets the default Date & Time used for all Excellentables under this Instance. 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 Instance Settings.
Click drop down next to Date & Time.
You will have the ability to search for the Date & Time format 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.

See also:

Space Level - Date & Time

Table Level - Date & Time