Datetime Fields

Using Application Composer, you can extend an application's object model by adding new fields to both standard or custom objects.

One such field type is datetime, where users in the runtime application can enter a date or select one from a calendar, and enter a time of day.

Datetime Field Properties

Create a datetime field by specifying values for the common set of field properties, such as display label and field name. You also set properties for this field that are specific to the datetime field type.

The following table shows properties that are common across multiple field types:

Field Property

Field Property Region

Label

Appearance

Help Text

Appearance

Name

Name

Description

Name

Required

Constraints

Updatable

Constraints

Searchable

Constraints

Indexed

Constraints

Fixed Value

Default Value

Note: When you select a literal date for this field's default value, the selected date appears in the international standard notation for date and time of day; however, at runtime, the date and time of day are displayed according to the user's preferences.

Expression

Default Value

Additional Datetime Field Specifications

Additional specifications for this field type include the following details:

  • Data type is TIMESTAMP.

  • A object can have a total of 625 fields. Of these, 50 are reserved for date and datetime fields.

  • When you create a custom subject area for custom reporting, you can select fields with this type to use for date leveling.

  • This field type supports time zone conversion.