Applications → Managing Fields → Field Settings → Options Tab of the Field Property Editor → Date/Time Field Options
Date/Time fields store dates and time values.
Select one of the display options for the field. Note that date/time values are always stored in native date/time format in the database. Values for Date/Time fields set to record time only or elapsed time are stored as integers. Assuming a default value of "Now", the value stored in the database is equal to the number of seconds that have passed since 12:00:00 a.m. in the submitter's or modifier's time zone.
Used for display of date-and-time values.
Used for display of date values.
Used for display of time values.
Stores a value representing an elapsed time in hours, minutes, and seconds. You can choose whether to include seconds in the display value, however. Users can provide an elapsed time in the format specified on the form (d hh:mm:ss, d hh:mm, hh:mm:ss, or hh:mm) or type an integer to represent the number of hours that should appear in the field. When you select this option, the Stopwatch, Calculate days, and Show seconds options become available.
The timer does not record elapsed time if it is moved to the Hidden Fields section. The stopwatch records time only when a form is open, so hiding the Stopwatch field in a state does not affect elapsed time. You must hide the Stopwatch field in the specific transition if you do not want it to record time. If the Stopwatch field is read-only or is placed in a field section the user does not have privileges or preferences to view, the timer still records elapsed time while the form is open. If the user cancels the transition or resets the form, the elapsed time is not saved.
To avoid incorrect stopwatch values, you should enable the Show seconds option when the Stopwatch option is enabled.
Select this option to make this field the only field to appear on a single row.
Search & Query
Select this option to include the field in lists on report forms. If you clear this option after the field is used in reports, the changed setting is ignored for those reports and the field is still shown until it is removed from the report definition.
Select this option to add the field to the Auxiliary Data search form in SBM Application Administrator and the Advanced Lookup Tool and Relational Field Value Lookup forms. For a Date/Time field, this option adds Start and End boxes next to the field on the lookup form, letting users specify a start and end date as part of their search criteria.
The field order for the Advanced Lookup Tool and Relational Field Value Lookup forms for primary items is determined by the default field order of the table's first project in the project hierarchy. Projects are defined in SBM Application Administrator.
Select this option to specify that the field will be available for selection on the Advanced Search page. This setting applies to primary and auxiliary tables. See Configuring Advanced Search for additional information.
Copyright © 2007–2015 Serena Software, Inc. All rights reserved.