Date-Time-Datetime
The utilization of the three date and time types necessitates specific guidelines for determining when they should be assigned a dedicated value through the 'Default value' field in the Metadata menu.
An incorrect setting may result in an 'Invalid Date' error.
It is crucial that the Pre-Resolve checkbox for the designated metadata value is enabled.
DATE
Setting metadata for a date is straightforward.
For example: Date - 2024-09-02
Default value: +0
Today -> 2024-09-02
Default value: +1
Tomorrow -> 2024-09-03
Default value: -1
Yesterday -> 2024-09-01
Default value: +10
-> 2024-09-12
In addition to using the symbols + or - with an integer for inputting dates, you can also use the YYYY-MM-DD pattern or the wildcards {date.year}-{date.month}-{date.day}.
The input dialogue for configuring or modifying the metadata field appears as follows:
TIME
Setting the time can be achieved by inputting the time in the following pattern: HH:mm or by using the wildcards {time.hour}:{time.minute}.
Please note that seconds cannot be used with this metadata type.
For example: current time - 12:23
Default value: {time.hour}:{time.minute}
-> 12:23
The input dialogue for configuring or modifying the metadata field appears as follows:
DATETIME
Datetime is a combination of date and time. Setting the metadata can be done manually by using a string with this pattern: YYYY-MM-DD HH:mm
It is possible to set this as well with dedicated wildcards:
{date.year}-{date.month}-{date.day} {time.hour}:{time.minute}
For example: current date & time - 2024-01-09 12:23
Default value: {date.year}-{date.month}-{date.day} {time.hour}:{time.minute}
-> 2024-01-09 12:23
It is possible to use contextual date wildcards as well, for further information refer to
Please ensure strict adherence to the pre-defined syntax when assigning a default value.