Skip to content

Date-time formats, codes, display rules


Anindita Basu    Feedback

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.

See also


Did this page help? No help at allYes, totally!
Back to top