Attribute types: Date

Avatar
Alica Kačengová

Date attribute type lets you enter dates and times in multiple formats.

When setting the type, you can specify the format by either choosing one of the pre-defined or using a custom one.

You can even create your own date format from the following formulas:

FormulaMeaning
YYYY, YYYears 2021, 21
MM, MMonths 01-12, 1-12
DD, DDays 00-31, 0-31
HH, HHours 00-23, 0-23
hh, hHours 00-12, 0-12
mm, mMinutes 00-59, 0-59
ss, sSeconds 00-59, 0-59
S, SS, SSSMilliseconds 0-999
a, Aam/pm, AM/PM
DDD, DDDDDay of year 1-365
ddd, ddddDay of week Mon, Monday
e, EDay of week 0-6, 1-7
WW, WWeek of year 01-53, 1-53
x, XTimestamp 1410715640579, 1410715640.579
Z, ZZOffset from UTC +12:00

After clicking into the cell, a datepicker will appear. When you select a date, it is automatically saved in the correct format.

Attributes of type Date are useful in multiple views. You can use them in e.g. in calendar, timeline or pivot view.

Example use case

Consider this table which we use to store information about tasks. It contains a summary of the task, start date and due date. We add the first row – you can of course enter dates without attribute type set and Lumeer will treat them as a text.

Then more people start to collaborate on the table and add new records. If they are guest users, they don’t even see other records (and their date formats) and this can easily result in a situation similar to this:

Obviously, such a situation is not desired and we want to prevent it from happening. Date attribute type does exactly that – you can set the format and also set minimum or maximum value if you wish.

Invalid values in the third row are now underlined – that way you or your colleagues will easily spot them and fix them.