cancel
Showing results for 
Search instead for 
Did you mean: 

No of days

Former Member
0 Kudos

Hi,

I am trying to calculate the no of days diff between DATE1 and current date at BEX level. DATE1 is in the infocube and I want the no of days between DATE1 and system date.

There is a system variable 0DAT which returns the current system date.

I am trying to define a formula variable to calculate the Diff between DATE1 and system date.

When I try to define a formula variable based on 0DAT , i dont find the )DAT variable in the drop down.

Please let me know soon if anybody has worked on this.

Accepted Solutions (0)

Answers (3)

Answers (3)

jaya_mogali
Contributor
0 Kudos

Hi Bill,

DATE1 is KF or Characteristic?

If it is characteristic create Formula variable using replacement path for Characteristic Date1.

Activate business content Formula variable 0F_ADAY which gives current calendar date.

Create a formula in BEx for calculating difference in dates

Jaya

Former Member
0 Kudos

Hi Bill,

Could you please walk me through to calculate the No. of Days at Bex level.

Many Thanks,

Ravi Kumar

Former Member
0 Kudos

Hi Guys,

Sorry...This is done 0DAT is not a formula variable. I used 0F_ADAY and its working fine. In this case you need to use business content formula variables.

Cheers,

Bill