FORMAT Function

Description

Format Dates and Times

The formatting is in moment.js format for Kintone App customizations and Arrow format for the Job Runner version. Both commonly used Formats are the same.

• Formatting for momentum.js
• Corresponding Formatting in Arrow

Usage Examples

Example: In the datetime field, format the date part as “01/05/2019” and the time part as “08:05”.

=format(Date_2, "YYYY/MM/DD")

Example: In the datetime field, format the date part as “1/5/2019” and the time part as “8:05” (no zero padding of numbers).

=format(Date_2, "YYYY/MM/DD")

Example: Format only the date portion of the datetime field value in a format such as “2019-01-05”.

=format(Date_2, "YYYY/MM/DD")

Example: Format the date field value in a non-delimited format, such as “20190105.”

=format(Date_2, "YYYY/MM/DD")

Example: Extract only the year from the date field.

=format(date_2, "dddd")

Example: Format the time using a 12-hour clock, such as 10:00 AM.

= format(Datetime_1, "A hh:mm")

Example: Format the date and day of the week as ‘Saturday, 2019-01-05’.

=format(Date_2, "YYYY/MM/DD")

Precautions

• The time zone for interpreting datetime, time is as follows:

  • In the customized Kintone app, the user’s device (PC, smartphone) is interpreted in the default time zone. The time zone for Kintone user profiles is not used.
  • In the Job Runner version, the time zone is determined by the setting in Set Time Zone.

• The language used to display the name of the month and the day of the week is as follows:

  • In the customized Kintone app, the language will match the logged-in user’s preference.
  • In the Job Runner version, it is always in Japanese.

関連記事

• How Do I Return Only the Date or Only the Time From a Date and Time Field?