Date difference formula issue

[mv1985]

Hello,

We have a requirement to calculate no of days using current system date and date coming from an info-object ZOR_DATE( characteristics ) in InfoCube at BEx Level. We have 0CALDAY also in our query. Please tell what can be done to find the number of days subtracting those mentioned days. We need to create a new formula or CKF ? Please tell in detail.

Thanks,

MV

[former_member186053 · Accepted solution]

Hi MV,

Create two formulas with two formula variables to get the date difference.

please go through the below doc.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/705734f2-4e85-2e10-2ebf-891d0110d...

Regards,

Vengal.

[mv1985 · Accepted solution]

Thanks Vengal,

I was able to achieve it creating two formula variables, one with customer exit to capture current date, CMOD code and another with replacement path and subtracted both.

Regards,

MV