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.