Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
typeflat
separatorpipe
printablefalse

Overview

Provides information about dates.

Details

Name:

Date Supplier

Prefix:

date(optional)

Supported Content:

Dates

Provided By:

Reporting for Confluence

Supported Keys

The following is the list List of keys which that this supplier will return returns a value for.

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

(Since 3.3.0) The

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

Status

year

colour

Date

Blue

Number

title

(Since

From 3.3.0

) The

year

Date

Number

The year value for the date.

Status
colourBlue
titleFrom 3.3.0

month of year

Date

Number

(Since 3.3.0) The

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

Status
colourBlue
titleFrom 3.3.0

day of month

Date

Number

(Since 3.3.0) The

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

Status
colourBlue
titleFrom 3.3.0

day of year

Date

Number

(Since 3.3.0) The

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

Status
colourBlue
titleFrom 3.3.0

hour of day

Date

Number

(Since 3.3.0) The

The hour of the day, from 0 to 23.

Status
colourBlue
titleFrom 3.3.0

minute of hour

Date

Number

(Since 3.3.0) The

The minute of the hour, from 0 to 59.

Status
colourBlue
titleFrom 3.3.0

second of minute

Date

Number

(Since 3.3.0) The

The second of the minute, from 0 to 59.

Status
colourBlue
titleFrom 3.3.0

milli of second

Date

Number

(Since 3.3.0) The

The millisecond within the second, from 0 to 999.

Status
colourBlue
titleFrom 3.3.0

shift \ /-X

Date

Date

(Since 3.3.0) Shifts

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

Status
colourBlue
titleFrom 3.3.0

This is a combination of digit/letter pairs representing a particular amount of time.

Eg.

For example, "shift \ 1d 2m 3y" will shift the date forward 1 day, 2 months, and 3 years.

Valid time periods are:

  • y -

Year
  • year

  • m -

Month
  • month

  • w -

Week
  • week

  • d -

Day
  • day

  • h -

Hour
  • hour

  • min -

Minute
  • minute

  • s -

Second
  • second

round to X

Date

Date

(Since 3.4.0) Rounds

Rounds the date to the specified time period

. It "

.

Status
colourBlue
titleFrom 3.4.0

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

Info

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

e.g.:

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.

e.g.:

"

For example

  • dd-

MMM
  • MM-yyyy

"
"
  • hh:mm:ss

a"