Skip to Content
Former Member
Dec 21, 2016 at 08:01 AM

Calculate difference of 2 dates in SAP BPC 10.0 NW


Hello Experts

For the purpose of calculating "End of service benefit" in HR Planning, we have a requirement to calculate the difference between joining date and current date.

We have loaded the "Date of Joining" attribute from 0Employee info object in BPC dimension.If the user enters the current date , it should calculate the difference.

for eg:employee xxx has joining date as 01/12/2016 and current date is 31/12/2016.Diff is 30 days.

The challenge above is that the "Date of Joining" is in EPMMemberProperty(, EPMMemberID(B14), "DOJ") and current date is in "Date format" due to which I am getting and "#VALUE" error.Is there any solution in which I can copy the EPMMember property to date format? or any epm formula?