Skip to main content

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?

  1. Follow instructions in How to get to Instance Settings.
  2. Click drop down next to Date & Time.
  3. 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?

ExampleToken Code
2021-01-05yyyy-mm-dd
01-05-2021mm-dd-yyyy
1/5/21m/d/yy
01/05/21mm/dd/yy
1/5m/d
5-Jand-mmm
5-Jan-2021d-mmm-yyyy
January 5, 2021mmmm d, yyyy
Jan 5, 2021mmm d, yyyy
January 5mmmm d
1:30:30 PMh:mm:ss am/pm
1:30 PMh:mm am/pm
13:30:30h:mm:ss
13:30h:mm
Tuesday, January 5, 2021dddd, mmmm d, yyyy
Tuesday, January 5, 2021 at 1:30:30 PMdddd, mmmm d, yyyy at h:mm:ss am/pm
Tuesday, January 5, 2021, 1:30:30 PMdddd, mmmm d, yyyy, h:mm:ss am/pm
Token CodeDescription
hHour of the day. Switches between 12 and 24 hour format depending on whether an am/pm indicator is present in the string.
mIf 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).
mmAs above, but with a leading 0 for both cases.
mmmThree letter month abbreviation (e.g., "Feb").
mmmmFull month name. mmmmmm+ also matches this.
sSeconds in the minute without a leading 0.
ssSeconds in the minute with a leading 0.
dDay of the month, no leading 0 for numbers less than 10.
ddDay of the month, with a leading 0 for numbers less than 10.
dddDay of the week, three letter abbreviation (e.g., "Mon").
ddddDay of the week, full name.
y2-digit year.
yyyy4-digit year.
am/pmAs above, but displays "AM" or "PM" instead and is always capitalized.


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.