All eazyBI for Jira eazyBI for Confluence Private eazyBI

TimestampToDate

EAZYBI Transforms date and time from timestamp format (integer) to date format.

Syntax

TimestampToDate(Numeric_Expression)

Arguments

Numeric_Expression

Unix timestamp value in integer format.

Examples

The following example returns the date of when an assignee was first assigned to the issue:

TimestampToDate(
  (
    [Measures].[Transition to first timestamp],
    [Transition Field].[Assignee]
  )
)

Be sure to set the Formatting for the measure to Date format.

It's important to remember to convert timestamps to dates before using date-specific functions.
The following example returns the lead time from the time that the issue received first assignee till the resolution date:

DateDiffDays(
  TimestampToDate(
    (
      [Measures].[Transition to first timestamp],
      [Transition Field].[Assignee]
    )
  ),
  [Measures].[Issue resolution date]
)

See also

  • Use DateToTimestamp() function to convert date and time from date format to timestamp format.