All eazyBI for Jira eazyBI for Confluence Private eazyBI

DateWithoutTime

EAZYBI Returns the date without the time from the provided date or string argument.

Syntax

DateWithoutTime(date_time_string)

Arguments

date_time_string
String expression for date or date time

Examples

To return Issue created date without exact time, use following expression DateWithoutTime([Measures].[Issue created date]).

Instead of returning e.g. 2014-10-01 17:43:28 only the date would be returned as 2014-10-01.

The formula below will compare resolution date to due date. Resolution date contains time component and you would like to remove it when comparing to due date to include as due in time when issue resolution date is in the same when due date.

  DateCompare(
   [Issue].CurrentMember.get('Due date'),
   DateWithoutTime([Issue].CurrentMember.get('Resolved at'))

See example report Issues due and overdue in our demo account. Calculated measure Issues due in time uses the formula above as a filter to compare if issue is resolved before or within due date.