Date calculations

[Former Member]

Hi All,

I have requiremnet like to display the (ageing Date) form the materail posting date -(minus) current date

my BI report should display like ...

material created date --- material currenrt date = No of days material in service

how to do date calculations for this scenario

Regards

Raj

[pavan_mankineni · Accepted solution]

Hi,

If u want to calculate difference between two dates create two formula variables with replacement path, one variable for each date char, use these two formula variables and create a new formula, ur problem will solve.

Thanks,

Pavan.M

[Former Member]

Hi,

create a formula variable to display the no. of days(ie Materuial created - current date).

suppose YMATCD is the material created date then write a formual :

nodim(YMATCD-0DATE)

0DATE will always gives u current date. and both are date variables. so u can directly use them in subtraction.

REDDY

[yogesh8984]

Hi,

Go thru the following link.

http://www.sd-solutions.com/documents/SDS_BW_Replacement%20Path%20Variables.html

The detailed procedure is explained with the screenshots. Its very helpful.

Regards,

Yogesh

[Former Member]

Create a formula variable on these two dates and subtract them. YOu will get the difference.

Thanks..

Shambhu