Write, Bureaucrats, Administrators
4,332
edits
DateTime field: Difference between revisions
m
no edit summary
mNo edit summary |
mNo edit summary |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Stamp| | {{Stamp|2023-08-12|5.0|2.0}} | ||
A DateTime field may contain a value that | {{BannerMenu}} | ||
{{PageTitle|DateTime field}} | |||
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. | 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, | 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. | |||
{{FieldNameHint}} | {{FieldNameHint}} | ||
| Line 20: | Line 27: | ||
{{FieldRequired}} | {{FieldRequired}} | ||
{{FieldDataValidationBase}} | |||
== Display Options == | == Display Options == | ||