Field types

Date and time

Field type datetime. A timestamp, stored as YYYY-MM-DD HH:MM:SS. The controls are borrowed: the calendar from date, the clock face from time, and with them their keys. Data entry from the cataloguer’s side is described under Date and time .

Date and time field Eingang im Haus (arrival at the museum) in Moliri: year, month and day on the left, the time with the clock face open on the right, next to it the Now button

Parameters

KeyValuesIf omittedEffect
yeartrue, falsetrueShow and edit the year
monthtrue, falsetrueShow and edit the month
daytrue, falsetrueShow and edit the day
calendar.langLanguage code, for example de-DEinterface languageLanguage of the month and weekday names
timetrue, falsetrueRecord the time. Off: the clock face is dropped and the time stays 00:00:00
formatFormat patternHH:mmPositions on the clock face. HH:mm:ss records seconds
precisionStep size00:01Smallest step, for example 00:15
minimumTime00:00:00Earliest value that can be chosen
maximumTime23:59:59Latest value that can be chosen
separatorCharacter:Separator in the time display
open_time_pickertrue, falsetrueOpens the clock face after the date has been chosen
show_nowtrue, falsetrueButton that enters the current moment and saves it at once
show_relativetrue, falsefalseShows the distance from now next to it, for example “3 hours ago”
autosizetrue, falsefalseWidth of the clock face follows the content
accent_colorColouremptyAccent colour of the clock face

A click in the calendar always sets year, month and day. Partial dates come about only by typing, and only by cutting parts off from the end. If you mostly record partial dates, use date.

Formatting

The field type comes with Timestamp DD.MM.YYYY HH:MM. It shortens partial dates and leaves out 00:00:00. It is deliberately not preselected anywhere: the views follow each person’s own setting. See Formatting .

When another field type fits

NeedField type
Date without a time, incomplete dates tooDate
Time without a date, durationTime
Dating with a wording, the point in time of a procedure with participantsan event