Date Supplier

Overview

Provides information about dates.

Details

Name:

Date Supplier

Prefix:

date(optional)

Supported Content:

Dates

Provided By:

Reporting for Confluence

Supported Keys

List of keys that this supplier returns a value for.

Key

Content Types

Return Type

Description

Key

Content Types

Return Type

Description

milliseconds

Date

Number

The number of milliseconds between the date and midnight, January 1, 1970.

at midnight

Date

Date

The supplied date, shifted to midnight at the beginning of the day, in the current user's timezone. From 3.3.0

year

Date

Number

The year value for the date. From 3.3.0

month of year

Date

Number

The month of the year, with the first month starting at 1. From 3.3.0

day of month

Date

Number

The day of the month, with the first day starting at 1. From 3.3.0

day of year

Date

Number

The day of the year, with the first day starting at 1. From 3.3.0

hour of day

Date

Number

The hour of the day, from 0 to 23. From 3.3.0

minute of hour

Date

Number

The minute of the hour, from 0 to 59. From 3.3.0

second of minute

Date

Number

The second of the minute, from 0 to 59. From 3.3.0

milli of second

Date

Number

The millisecond within the second, from 0 to 999. From 3.3.0

shift \ /-X

Date

Date

Shifts the date to the specified time period 'X'. From 3.3.0

This is a combination of digit/letter pairs representing a particular amount of time. For example, "shift \ 1d 2m 3y" will shift the date forward 1 day, 2 months, and 3 years.

Valid time periods are:

  • y - year

  • m - month

  • w - week

  • d - day

  • h - hour

  • min - minute

  • s - second

round to X

Date

Date

Rounds the date to the specified time period. From 3.4.0

This is a combination of an amount and a time period.

If you specify " " or "-", it will round up or down, respectively, otherwise, it is to the nearest value.

For example

  • round to 1d - round up to the nearest day

  • round to -15min - round down to the previous 15-minute block

  • round to \ 1h - round up to the next hour

  • round to -1y - round down to the first day of the current year

[date format]

Date

Text

Attempts to convert the date to a text value using the key as a date format, as defined by SimpleDateFormat.

For example

  • dd-MM-yyyy

  • hh:mm:ss