Count of dates from start to end date or today

Questions & Answers
1

Hello,

I need to create a dashboard that shows the count of days from the start date to the end date, if an issue has an end date, and if it doesn’t have an end date then count from the start date to today

Appreciate your help.

2

Hi @wiezienaskabanu1,

You might use the DateDiffDays() function to find the time difference in days. Please read more about DateDiffDays() here - DateDiffDays.
You can also see nearby similar functions for hours, workdays, or workhours.

You might also use the CoalesceEmpty() function to replace the empty result with “today”. Please read more about CoalesceEmpty() here - CoalesceEmpty.

The full expression might look as follows.

DateDiffDays(
 [Issue].CurrentHierarchyMember.Get('Start date'),
 CoalesceEmpty(
  [Issue].CurrentHierarchyMember.Get('End date'),
  "today")
)

You might adjust the expression with the correct issue property names for start and end dates.

Regards,
Oskars / support@eazyBI.com