Date
Placing a "Date" field on your app form creates an input field for entering dates in the "month-date-year" format.
If you click a date input field on the "New Record" or "Edit Record" screen, a calendar appears from which you can choose a year, month, and day. 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.
"Date" field settings
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.
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
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.
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.