Sorting by dates is now easier by using normalized date values to be used with Lucene searches. If the property value is specified with the Confluence Date Autocompletion (opened with the shortcut '// '), and for the creation and last modification date, a normalized date is provided as an artificial property.
The name of this artificial property is that of the original property plus the § -sign appended. Here is an example where the creation date is check against a custom property named Last Update . Code Block |
---|
| $[Creation Date§]: [${Last Update§} TO NOW] |
There is also an artificial property value containing the date as a timestamp in milliseconds, prefixed with zeros up to 19 digits (%019d ). The name of the artificial property is constructed from the original name plus the suffix Timestamp (separated by a blank). Note that the Creation Timestamp is the creation date in milliseconds, while the Creation Date Timestamp is the representation of the date (without hours, minutes, seconds) in milliseconds. Tip Box |
---|
See Date Representation for details on provided artificial properties for the creation and last modification date. |
The change may break sort orders for instance in the Display Table Macro where the use of Code Block |
---|
Creation Date@{date} |
attempts to parse the date in the user's default format. With this version use Creation Date§ instead. |