Update: the knowledge base has been moved and is now available on Lumeer's website. Please visit Attribute types: Date to access the most recent version.


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 use the following formulas in your custom format, and Lumeer always shows you an example so you can check if it's right.


Formula

Meaning

YYYY, YY

Years 2021, 21

MM, M

Months 01-12, 1-12

DD, D

Days 00-31, 0-31

HH, H

Hours 00-23, 0-23

hh, h

Hours 00-12, 0-12

mm, m

Minutes 00-59, 0-59

ss, s

Seconds 00-59, 0-59

S, SS, SSS

Milliseconds 0-999

a, A

am/pm, AM/PM

DDD, DDDD

Day of year 1-365

ddd, dddd

Day of week Mon, Monday

e, E

Day of week 0-6, 1-7

WW, W

Week of year 01-53, 1-53

x, X

Timestamp 1410715640579, 1410715640.579

Z, ZZ

Offset from UTC +12:00


After submit, all existing values are converted to a new format.



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