Attribute types: Date
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:
|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 clicking into the cell, a datepicker will appear. When you select a date, it is automatically saved in the correct format.
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.