Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Returns number of days from first date to second date.

...

 DateDiffDays(from_date, to_date)

Arguments

from_date
MDX expression that returns a date.
to_date
MDX expression that returns a date.

Examples

Following example calculates how many days has the issue been in current status.

...

The above is an example how to use the DateDiffDays function. Note that more efficient way of calculating issues due in various age intervals would be to use the Age age intervals dimension.