Skip to Content
0
Former Member
Apr 02, 2015 at 09:23 PM

Need to find difference between two date and time dimension in WEBI?

1814 Views

Hi Folks,

Kindly help me how to find difference between two date and its time.

Ex: Modified Date- Jan 01 2010

Creation Date- Dec 10 2009

Also need find difference of time like this

Modified Time: 10:10

Creation Time: 9:00

Expected Output: 22 days and 1:10 hrs of time

I used below formulas to find the difference, but not work out

=Format date([Modified Date];"d"-[Creation Date];"d")

here I'm getting some function missing

Even I tried

=datediff(dd;[Modified Date];[Creation Date])

here datefiff function not found under webi.

Kindly suggest me best solution for this.