No of days

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.