DateTime field

From Memento Database Wiki
Jump to: navigation, search
« 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 and Hint

Standard across all field types.

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 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

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.