DateTime field

From Memento Database Wiki
Jump to navigation Jump to search
« 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:
  • 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.