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.