Date

Article Number:040521

Placing a Date field on your app form creates an input field for entering a day, month, and year.
Screenshot: Example of a "Date" field

If you click a date input field on the New record or Edit record screen, a calendar appears from which you can choose a day, month, and year. You can change the year and month of the calendar from the year and month drop-down lists.
You can also use your keyboard to directly enter a date in the input field.

Screenshot: A calendar is displayed on the "New Record" screen

"Date" field settings

Screenshot: The settings screen of a "Date" field

Name

Specify the field name. The field name is displayed as the label of the field in the app.

Hide field name

Selecting the Hide field name checkbox hides the field name on the following screens.

  • The New record screen
  • The Edit record screen
  • The Record details screen
  • The screen for printing a record
  • The form settings screen

Required field

Selecting the Required field checkbox makes specifying a field value mandatory.

Prohibit duplicate values

Selecting the Prohibit duplicate values checkbox prohibits the same date value from being specified in multiple records.

Default value

This setting lets you set a default field value.

If you want to make the default field value the date when the record was created, select the Default to the record creation date checkbox .
If you want to enter a different date as the default value, uncheck the Default to the record creation date checkbox and enter the date of your choice in the input field.
If you do not want to set a default value, uncheck the Default to the record creation date checkbox and leave the date input field blank.

Field code

The character string used for specifying the field in APIs.

Date format for input fields

The date format of input fields will differ depending on the user's display language and web browser language settings.

Year-Month-Day

To enter and display a date in the "Year-Month-Day" format, one of the following conditions must be met.

  • The language in your account settings is set to a language other than English (e.g., Japanese).
  • The language in your account settings is set to Use Web browser settings and the language of your web browser is not set to either of the following:
    • English (United States)
    • English

Month/Day/Year

To enter and display a date in the "Month/Day/Year" format, one of the following conditions must be met.

  • The language in your account settings is set to English.
  • The language in your account settings is set to Use Web browser settings and the language of your web browser is set to either of the following:
    • English (United States)
    • English

Usage examples

Use a Date field when you want an input field for entering a date. For example, you can use a Date field in the following ways.

  • As a field for entering a date of use in a transportation expense approval app or an app for requesting approval for other expenses
  • As a field for entering a reply deadline in an inquiry management app
  • As a field for entering an activity date in a case management app

Screenshot: An example of a "Date" field being used as a field for entering an activity date

Use a "Date" field to calculate deadlines

Since Date fields can be specified in formulas, you can set a formula for displaying a reply deadline of two days after the date in the Date field.

In this example, the formula is set in a Calculated field.
Place a Date field and a Calculated field on your app form, specify the following formula in the Calculated field, and set the calculation result to be displayed as a date.

The content has been copied.
Date+(60\*60*24)*2

For more information on Calculated fields, refer to Calculated.
For information on how to calculate dates, refer to Calculation of date, time, and date and time.