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.