DateTime field

« Page as of 2018-09-27, editions Mobile 4.5.5, Desktop 1.1.0 »

---

A DateTime field may contain any date of the Gregorian calendar and the time of day.

When a DateTime field's value is used in a Calculation field, the value used is that used by Unix and Linux systems to represent dates & times, which is the number of seconds before or since January 1, 1970. When a DateTime field's value is used in a JavaScript field or in Memento scripts, the value used is based on that used by Unix and Linux systems to represent dates & times, but is in milliseconds (instead of seconds) before or since January 1, 1970. Moments in time prior to that are negative numbers.

This value allows date/time arithmetic to work readily, by merely doing integer arithmetic with the value.

When a DateTime value is interpreted for import, export, or display in years, months, days, hours, minutes, and seconds, the current locale is used. The format for import and export can be specified in program settings.

A reminder may be set during field edit. It sets a reminder using the device's reminder notification mechanism. The value of the reminder does not appear in the data.

Name

Textual, case-insensitive field identifier that can include spaces; it's best to avoid characters that can be used as operators, though (standard across all field types)

Hint

Textual, case-insensitive field identifier that can include spaces

Advanced Parameters

Default Value

By default, there is no default value. Alternatively, the default may be set to the current date and time as of entry or edit of the field within an entry.

« The Date and time formats parameter applies to the mobile {{{3}}} edition only »

Date and time formats

The format may be specified explicitly. Selecting Date and time formats causes a card to appear in which these properties may be changed:

Language

The language/locale may be set.

Short date

The user may select among a number of choices for the short form of a date.

Long date

The user may select among a number of choices for the long form of a date.

Short time

The user may select among a number of choices for the short form of a time.

Long time

The user may select among a number of choices for the long form of a time.

Required

Make entry of a value mandatory before saving an entry

Data validation

The value of a field may be validated against user-specified criteria. If the validation fails, an error message is displayed on the screen by the field, and the user must take action to resolve the situation before saving the entry.

Display Options

Display in the list as

Select among the following roles for the current field in the entries list:

• As a Regular field
• As an Entry Name
• As an Entry Description
• As an Entry Status

Use in calendar as

The field's value may be used as a start or end time in the calendar.

The field name

Display the name of the field in the card entry (By default, On). By this, it is meant that the field name will or will not be displayed on either the Entry View card or the Entry Edit card.

Font

Choices are:

• Family: Regular, Light, Condensed, Thin, Medium. By default, Regular.
• Style: Normal, Bold, Italic, Bold Italic. By default, Normal.
• Size: By default, 18. Direct entry to change.
• Color: By default, White. Palette of 20 colors, backed up by a continuously variable color chooser.

Dependencies

Ability to add one or more visibility dependencies upon fields with qualifying types.