How do I calculate 2 date fields and find its difference?

Hi All,

how do I calculate 2 date fields and find its difference?

-Syed KM

Hi, @SyedMoin

Welcome to the eazyBI community.

The formula you are looking for is DateDiffDays.

You can find all the functions in our documentation under MDX Function reference

Kind regards,
Ilze support@eazybi.com

Thank you, but can we calculate the time difference between the custom fields?
for ex: Planned start date - Planned end date