Skip to Content
0
Former Member
Mar 06, 2009 at 07:24 AM

Find no. of days between dates

34 Views

Hi guys,

I have 5 dates with me, 2 of which are Key Figures and 3 are of Char. date type. Now, I have to find no. of days between these dates using various permutation and combination i.e. it can be between 2 KF's or 2 Char. types or 1 KF and 1 Char. type as well.

1) I think finding no. of days between 2 KFs can be done using Cumulative KF.

2) I tried to find no. of days between 2 Charac. by creating a Formula (2 variables with Replacement Path) and then finding the difference. But the output seems to be wrong.

eg. 27.02.2009 - 19.01.2009 = 108 days, which is wrong!

(Posting date) (clearing date)

3) I also have to do it between 1 KF and 1 Char. date type, tried creating 1 variable for Char. and then subtracting with KF, but Report shows 'X' in the output!

Any suggestions?

Thanks.