Date range type
The Date range type (DateRangeValueType) dynamic enumeration specifies choices for the 'type' in the Relative date range with time value resolver:
All options except the 'Custom' type are predefined time specifications, for each of which a pattern for Start and End can be stored as a date calculation, which is applied relative to the current system time.
For the 'Custom' (CUSTOM) option, such patterns are ignored (they are empty by default), since patterns using the 'Start value' and 'End value' parameters in the Relative date range with time value resolver are used instead (see Relative date range with time for details).
In addition, the values in this dynamic enumeration define filter options for date and date range columns in data grids and overviews.
The following definitions for default values are predefined at delivery:
|
Name |
Localization (English) |
Start (Pattern) |
End (Pattern) |
Comments |
|
Timeline |
||||
|
LAST_SIXTY_MINUTES |
Last 60 minutes |
-60m |
<empty> |
... the last 3,600,000 milliseconds (= '60 minutes') |
|
LAST_12_HOURS |
Last 12 hours |
-12H |
<empty> |
... the last 43,200,000 milliseconds (= '12 hours') |
|
LAST_24_HOURS |
Last 24 hours |
-24H |
<empty> |
... the last 86,400,000 milliseconds (= '24 hours') |
|
LAST_7_DAYS |
Last 7 days |
0h 0m 0s 0S -6d |
23h 59m 59s 999S |
... the period from the beginning of the calendar day 6 days ago (-6d) |
|
Full hour (period) |
||||
|
THIS_HOUR |
Current hour |
0m 0s 0S |
59m 59s 999S |
... the period from the first to the last millisecond of the current (complete) hour |
|
LAST_HOUR |
Previous hour |
0m 0s 0S -1h |
59m 59s 999S -1h |
... the period from the first to the last millisecond of the previous (complete) hour (-1h). |
|
NEXT_HOUR |
Next hour |
0m 0s 0S +1h |
59m 59s 999S +1h |
... the period from the first to the last millisecond of the next (complete) hour (+1h). |
|
Calendar day (period) |
||||
|
TODAY |
Current day |
0h 0m 0s 0S |
23h 59m 59s 999S |
... the period from 'Start today' to 'End today' (see Date time type) |
|
YESTERDAY |
Previous day |
0h 0m 0s 0S -1d |
23h 59m 59s 999S -1d |
.... the period from 'Start of previous day' to 'End of previous day' (see Date time type) |
|
TOMORROW |
Next day |
0h 0m 0s 0S +1d |
23h 59m 59s 999S +1d |
... the period from 'Start of next day' to 'End of next day' (see Date time type) |
|
Calendar week (period) |
||||
|
THIS_WEEK |
Current week |
0h 0m 0s 0S 1E |
23h 59m 59s 999S 7E |
... the period from 'Start of week' to 'End of week' (see Date time type) |
|
LAST_WEEK |
Previous week |
0h 0m 0s 0S -7d 1E |
23h 59m 59s 999S -7d 7E |
... the period from 'Start of last week' to 'End of last week' (see Date time type) |
|
NEXT_WEEK |
Next week |
0h 0m 0s 0S +7d 1E |
23h 59m 59s 999S +7d 7E |
... the period from 'Start of next week' to 'End of next week' (see Date time type) |
|
Calendar month (period) |
||||
|
THIS_MONTH |
Current month |
0h 0m 0s 0S 1d |
23h 59m 59s 999S 1d +1M 0d |
... the period from 'Start of month' to 'End of month' (see Date time type) |
|
LAST_MONTH |
Previous month |
0h 0m 0s 0S 1d -1M |
23h 59m 59s 999S 0d |
... the period from 'Start of last month' to 'End of last month' (see Date time type) |
|
NEXT_MONTH |
Next month |
0h 0m 0s 0S 1d +1M |
23h 59m 59s 999S 1d +2M 0d |
... the period from 'Start of next month' to 'End of next month' (see Date time type) |
|
Calendar year (period) |
||||
|
THIS_YEAR |
Current year |
0h 0m 0s 0S 1d 1M |
23h 59m 59s 999S 12M 31d |
... the period from 'Start of year' to 'End of year' (see Date time type) |
|
LAST_YEAR |
Previous year |
0h 0m 0s 0S 1d 1M -1y |
23h 59m 59s 999S 12M 31d -1y |
... the period from 'Start of last year' to 'End of last year' (see Date time type) |
|
NEXT_YEAR |
Next year |
0h 0m 0s 0S 1d 1M +1y |
23h 59m 59s 999S 12M 31d +1y |
... the period from 'Start of next year' to 'End of next year' (see Date time type) |
|
Quarter (period) |
||||
|
THIS_QUARTER |
Current quarter |
0h 0m 0s 0S +0q |
23h 59m 59s 999S +0Q |
... the period from 'Start of quarter' to 'End of quarter' (see Date time type) |
|
LAST_QUARTER |
Previous quarter |
0h 0m 0s 0S -1q |
23h 59m 59s 999S -1Q |
... the period from 'Start of last quarter' to 'End of last quarter' (see Date time type) |
|
NEXT_QUARTER |
Next quarter |
0h 0m 0s 0S +1q |
23h 59m 59s 999S +1Q |
... the period from 'Start of next quarter' to 'End of next quarter' (see Date time type) |
|
Special time periods |
||||
|
IN_THE_PAST |
In the past |
0y 1M 1d 0H 0m 0s 0S |
999S |
... the time period from the beginning of the time calculation (see Date time type) to the last millisecond of the current second (999S). |
|
IN_THE_FUTURE |
In the future |
0S |
9999y 12M 31d 23H 59m 59s 999S |
... the time period from the first millisecond of the current second (0S) to the last millisecond of the year 9999. |
|
Freely definable |
||||
|
CUSTOM |
Custom ... |
<empty> |
<empty> |
... enables the definition of a 'custom' pattern via the 'time value' parameter in the Relative date with time value resolver |
|
System time |
||||
|
NOW |
Now |
<empty> |
<empty> |
no pattern necessary ('Now' = system time without offset) |
If required, custom 'date range types' with specific 'patterns' for Start and End can be added or, if necessary, existing ones can be removed.
CAUTION
The 'patterns' for Start and End for predefined entries can basically be edited and so customized according to individual requirements. However, any change to a predefined expression immediately and globally affects all existing references, e.g. also in default filters of overviews or if the Relative date range with time value resolver is used in criteria in the context of the Search API. This can have far-reaching consequences for the runtime behaviour of Lobster Data Platform / Orchestration as well as all Lobster_data profiles that use the Search API. If necessary, it is therefore advisable to assign alternative definitions from the default to specially added values for the calculation logic. Then, for each reference, there is a choice between the 'factory default' and a 'custom default'. If required, Dynamische Aufzählungsfilter can be used to restrict this selection, e.g. depending on Association Criteria.