Date-time formats, codes, display rules

The date and time formats work throughout the mobile and web app, except for notification messages and custom reports.

Dates that aren't within the current year are always in an absolute format (for example, 31/12/2020 8:32:45). For other dates and time, the defaults are these:

If the data is within a single day, relative format of time (for example, Now)
If the data is for a day, relative format of date (for example, In 5 days)
If the time stamp is important, absolute format of date and time (for example, 15 Apr 2020 09:23 PM)
If the data is streaming and recency is important, relative format of date and time (for example, 2 minutes ago)

Relative formats

The relative format is the default format for meetings where a date isn't already displayed and the date is in the current year. The date and time can be either in the past or in the future. Here are some examples:

Past, for example, Today, Now, 2 seconds ago
Future, for example, In 2 minutes, In 5 days

Absolute formats

The absolute format is the default format for all categories except for meetings where a date isn't already displayed and the date is in the current year.

The absolute format can be changed to any of the formats supported for a specific locale. You can have only one locale for a company. For the formats that you can use for a particular locale, see the page for that locale.

Date categories

The following table shows the format options available for the several date and time categories.

Category	Relative format available?	Default format, code, and example
Date display when date is in the current year	Yes	Absolute format `DD MMM YYYY` (01 Jan 1857) and `JA_DATE` (1857年1月1日)
Date display when date isn't in the current year	Yes	Absolute format `DD MMM YYYY` (01 Jan 1857) and `JA_DATE` (1857年1月1日)
Meeting display when a date is already displayed	Yes	Absolute format `HH:MM A` (06:45 pm) and `JA_TIME_HH_MM` (18:45)
Meeting display when a date isn't already displayed and the date is in the current year	Yes	Relative format When a relative value isn't available, the default absolute format is `ddd, DD MMM ᐧ H:MM a` (Sun, 01 Jan, 9:32 ᐧ pm) and `JA_DATE-TIME` (1857年01月01日. 21時32分)
Meeting display when a date isn't already displayed and date isn't in the current year	No	Absolute format `DD_MMM_YYYY-TIME` (01 Jan 1857 09:32 pm) and `JA_DATE-TIME` (1857年01月01日. 21時32分)
Date range	No	Absolute `DD MMM YYYY separator DD MMM YYYY` (01 Jan 1857 separator 01 Jan 1857) and `JA_DATE` (2020年9月7日)
X-axis in charts	No	Absolute format `MMM YY` (Jan 01)
Time when a date is already displayed	Yes	Absolute format `HH:MM` (13:44) and `JA_TIME_HH_MM`(13:44)
Time range	No	`HH:MM separator HH:MM` (13:44 separator 13:50)
Year and Month	No	Absolute format `YYYY_MM` (2020 01) and `JA_CAL_YYYY_MM`
Month and day	No	Absolute format `YYYY_MM` (2020 01) and `JA_CAL_MMM_DD`
Date time with seconds	No	Absolute format `DD_MM_YYYY_SLASH-TIME`

Display rules

The following table shows how the dates and time are displayed in the Vymo app and web. For examples for a specific locale, see the page for that locale.

Category	Allowed	Not allowed	Special rules
Date display when date is in the current year	Any date-only format that has at least 2 parts of the date	Any date-only format that has only 1 part of the date or only a time component (for example, `ccc`, `W`, `dd MMM, hh:mm a`, `EEEE` or `HH:mm`)	If the `dd` part is missing, only absolute formats can be used, not relative formats
Date display when date isn't in the current year	Any format that has a Year component.	Any format that has only 1 part of the date or only a time component (for example, `dd MMM`, `YYYY` or `HH:mm`)	If the `dd` part is used, Month must also be included.
Meeting display when a date is already displayed	Any time-only format	Any format that has only parts of the time (for example, `hh`, `mm`, or `HH`) or has a date component (for example, `dd MMM, hh:mm a` or YY)	Always includes the meeting duration as `X minutes` or `X hours Y minutes`. The display format should be set to `{ time } for { duration }`.
Meeting display when a date isn't already displayed and the date is in the current year	Any format that has up to 2 parts of the date, such as `dd MMM, hh:mm a`, `EEE, dd MMM, hh:mm a`, or `EEE, dd MMM`	Any format that doesn't contain the `dd` or Month part of the date, or contains only the time component (for example, `hh:mm a`)	Always includes the meeting duration as `X minutes` or `X hours Y minutes`. The display format should be set to `{ date } dot { time range } dot { duration }`, where the time range format is `{ from time } dash { to time }`.
Meeting display when a date isn't already displayed and date isn't in the current year	Any format that has the Year component, such as `dd mm yy`, `mm yyyy`, or `dd mm yyyy`	Any format that has only parts of the date, doesn't contain the year, or has only a time component, for example, `dd MMM, hh:mm a`, `MMM, dd`, `EEEE`, or `HH:mm`	Always includes the meeting duration as `X minutes` or `X hours Y minutes`. The display format should be set to `{ date } dot { time range } dot { duration }`, where the time range format is `{ from time } dash { to time }`.
Date range	Any format that has a Year component.	Any format that has only 1 part of the date or only a time component (for example, `dd MMM`, `YYYY` or `HH:mm`)	If the `dd` part is used, Month must also be included.
X-axis in charts	Any format that has the month and year components	Any other formats	If the default granularity is changed from monthly to daily, the day-month-year formats can be used.
Time when a date is already displayed	Any format that has hours and minutes, such as `hh:mm`, `hh:mm:ss`, or `dd mm yy hh:ss`	Any format that doesn't contain hours and minutes, such as `dd mm`, `hh:ss`, or `mm:ss`
Time range	Any format that contains `hh` and `mm`, such as `hh mm`, `hh:mm:ss`, or `dd mm yy hh:ss`	Any format that doesn't contain `hh` and `mm`, such as `dd mm`, `hh:ss`, or `mm:ss`	Always includes the meeting duration as `X minutes` or `X.x hours`. The time range format must be `{ from time } dash { to time }`.
Year and Month	Any format that contains Month and Year, such as `MMM_YYYY`, or `JA_CAL_MMM_YYYY`
Month and day	Any format that contains Month and Day, such as `MMM_DD`, or `JA_CAL_MMM_DD`
Date time with seconds	Any format that contains Month and Year, such as `DD_MM_YYYY_HH_MM_SS_SLASH`, or `DD_MM_YYYY_HH_MM_SS_SLASH`

Pre-defined date and time codes

Use the JSON interface to specify the date and time format to use for displays. The following code snippet is an example of a date and time format. You change the values for the category and dateTimeFormat keys.

{
      "disabled": false,
      "order": 10,
      "category": "date_in_curr_year",
      "dateTimeFormat": "JA_DATE",
      "relativeFormat": false
    },

The following table shows the formats that you can use for each of the categories.

Custom formats

Don't create a custom format code. Use only the codes tabulated here.

You can use either the EN format or the JP format for a company, but not both.

Format	date_in_curr_year	date	time	meeting_date_time_in_curr_year	meeting_date_not_in_curr_year	date_range	date_in_chart	time_range
HH_MM_A	X	X	Yes	X	X	X	X	Yes
HH_MM_CAPA	X	X	Yes	X	X	X	X	Yes
H_MM_A	X	X	Yes	X	X	X	X	Yes
H_MM_CAPA	X	X	Yes	X	X	X	X	Yes
HH_MM	X	X	Yes	X	X	X	X	Yes
H_MM	X	X	Yes	X	X	X	X	Yes
HH_MM_SS	X	X	Yes	X	X	X	X	Yes
HH_MM_SS_A	X	X	Yes	X	X	X	X	Yes
H_MM_SS	X	X	Yes	X	X	X	X	Yes
HH_MM_SS_A	X	X	Yes	X	X	X	X	Yes
H_MM_SS	X	X	Yes	X	X	X	X	Yes
H_MM_SS_A	X	X	Yes	X	X	X	X	Yes
JA_TIME_HH_MM_SS	X	X	Yes	X	X	X	X	Yes
JA_TIME_HH_MM	X	X	Yes	X	X	X	X	Yes
JA_TIME_HH_MM_A	X	X	Yes	X	X	X	X	Yes
JA_TIME_SYM_HH_MM	X	X	Yes	X	X	X	X	Yes
JA_DATE	Yes	Yes	X	Yes	Yes	Yes	Yes	X
JA_DATE_YYYY_MM	Yes^*	Yes	X	Yes	Yes	Yes	Yes	X
JA_MMM_DD	Yes	X	X	Yes	X	X	X	X
DD_MMM_YYYY	Yes^*	Yes	X	Yes	Yes	Yes	Yes	X
YYYY_MM	Yes^*	Yes	X	X	Yes	Yes	Yes	X
DAY_DD_MMM-TIME	Yes	X	X	Yes	X	X	X	Yes
DD_MMM_YYYY-TIME	Yes	Yes	X	Yes	Yes	Yes	Yes	Yes
DD_MMM-TIME	Yes	X	X	Yes	X	X	X	Yes
DAY_DD_MM	Yes	X	X	Yes	X	X	X	X
MMM_YY	Yes^*	Yes	X	X	Yes	Yes	Yes	X
MM_DD	Yes	X	X	Yes	X	X	X	X
DD_MMM	Yes	X	X	Yes	X	X	X	X
MM_YYYY	Yes^*	Yes	X	Yes	Yes	Yes	Yes	X
MMM_DD_YYYY	Yes	Yes	X	Yes	Yes	Yes	Yes	X
DD_MMM_YY_HYPHEN	Yes	Yes	X	Yes	Yes	Yes	Yes	X
DD_MM_YYYY_SLASH	Yes	Yes	X	Yes	Yes	Yes	Yes	X
^* Only absolute formats can be used.