Times & Dates
Date Formats
Dates are displayed in one of three primary formats, depending on the context:
- Relative
This is the preferred format to display dates. Depending on the event's relation to the present time, this may take one of several wordings. When using this format, be sure that the phrase has proper grammar when read in context.
- Concise
This short format is used whenever horizontal space is constrained and the date must be as narrow as possible.
- Machine Format
This is the most technically accurate format. It is used for data tables, query run information, and other scenarios where technical accuracy is important.
Event is...
1. Relative
2. Concise
3. Machine Format
MMM DD YYYY at XX:XX AM/PM
e.g. Jun 2 2019 at 1:23 PM
e.g. Jun 2 2019 at 1:23 PM
MM/DD/YY
e.g. 06/02/19
e.g. 06/02/19
MM/DD/YY HH:MM AM/PM
e.g. 06/02/19 1:23 PM
e.g. 06/02/19 1:23 PM
In
In N days at XX:XX AM/PM
e.g. In 2 days at 1:23 PM
e.g. In 2 days at 1:23 PM
In 3+ days
MM/DD/YY
e.g. 06/02/19
e.g. 06/02/19
MM/DD/YY HH:MM AM/PM
e.g. 06/02/19 1:23 PM
e.g. 06/02/19 1:23 PM
Tomorrow
Tomorrow at XX:XX AM/PM
e.g. Tomorrow at 1:23 PM
e.g. Tomorrow at 1:23 PM
MM/DD/YY
e.g. 06/02/19
e.g. 06/02/19
MM/DD/YY HH:MM AM/PM
e.g. 06/02/19 1:23 PM
e.g. 06/02/19 1:23 PM
Later today
Today at XX:XX AM/PM
e.g. Today at 1:23 PM
e.g. Today at 1:23 PM
HH:MM AM/PM
e.g. 1:23 PM
e.g. 1:23 PM
MM/DD/YY HH:MM AM/PM
e.g. 06/02/19 1:23 PM
e.g. 06/02/19 1:23 PM
In
In X minutes
e.g. In 13 minutes
e.g. In 13 minutes
HH:MM AM/PM
e.g. 1:23 PM
e.g. 1:23 PM
MM/DD/YY HH:MM AM/PM
e.g. 06/02/19 1:23 PM
e.g. 06/02/19 1:23 PM
In
In X seconds
e.g. In 13 seconds
e.g. In 13 seconds
HH:MM AM/PM
e.g. 1:23 PM
e.g. 1:23 PM
MM/DD/YY HH:MM AM/PM
e.g. 06/02/19 1:23 PM
e.g. 06/02/19 1:23 PM
Now
X seconds ago
e.g. 13 seconds ago
e.g. 13 seconds ago
HH:MM AM/PM
e.g. 1:23 PM
e.g. 1:23 PM
MM/DD/YY HH:MM AM/PM
e.g. 06/02/19 1:23 PM
e.g. 06/02/19 1:23 PM
X minutes ago
e.g. 13 minutes ago
e.g. 13 minutes ago
HH:MM AM/PM
e.g. 1:23 PM
e.g. 1:23 PM
MM/DD/YY HH:MM AM/PM
e.g. 06/02/19 1:23 PM
e.g. 06/02/19 1:23 PM
Earlier today
Today at XX:XX AM/PM
e.g. Today at 1:23 PM
e.g. Today at 1:23 PM
HH:MM AM/PM
e.g. 1:23 PM
e.g. 1:23 PM
MM/DD/YY HH:MM AM/PM
e.g. 06/02/19 1:23 PM
e.g. 06/02/19 1:23 PM
Yesterday
Yesterday at XX:XX AM/PM
e.g. Yesterday at 1:23 PM
e.g. Yesterday at 1:23 PM
Yesterday at 1:23 PM
N/A
06/02/14 1:23 PM
N/A
06/02/14 1:23 PM
MM/DD/YY HH:MM AM/PM
e.g. 06/02/19 1:23 PM
e.g. 06/02/19 1:23 PM
N days ago at XX:XX AM/PM
e.g. 2 days ago at 1:23 PM
e.g. 2 days ago at 1:23 PM
MM/DD/YY
e.g. 06/02/19
e.g. 06/02/19
MM/DD/YY HH:MM AM/PM
e.g. 06/02/19 1:23 PM
e.g. 06/02/19 1:23 PM
3+ days ago
MMM DD YYYY at XX:XX AM/PM
e.g. Jun 2 2019 at 1:23 PM
e.g. Jun 2 2019 at 1:23 PM
MM/DD/YY
e.g. 06/02/19
e.g. 06/02/19
MM/DD/YY HH:MM AM/PM
e.g. 06/02/19 1:23 PM
e.g. 06/02/19 1:23 PM
Last Updated
Aug 13, 2019