Table Level - Date & Time
What does Date & Time mean?
Setting the Date & Time at the Excellentable Level sets the default Date & Time used for this specific Excellentable. 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 Table 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?
|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|
|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|
|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.|
|am/pm||As above, but displays "AM" or "PM" instead and is always capitalized.|