|String expression for date or date time
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
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.
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.