Display Current system date in query and calculate difference

[Former Member]

Hi Folks

I need to display the current system date in my query. Also by using this current system date i need to take difference on an another date , so i can display the number of days between these two dates .

I'm using BI 7.0 BEx analyser.

From

Manesh

[Former Member]

SOlved......

[Former Member]

Hi,

Please reply how you solved it. I have to put number of days calculated between invoice date and system date.

Thanks,

~S

[Former Member]

Hi

Sorry! Sidd for late response.

First i want to know......

Are you able to dispaly ur invoice date in the keyfigures column ?

From

Manesh

[Former Member]

Hi Manesh

Can you post how did you solve this? Can I display a date as a keyfig or use it for calculation? Thanks!

[Former Member]

Hi manesh,

i would like to know what time characteristic you got in your query, based on that or 0DAY , u can create a variable with using replacement path. otherwise Please use 0P_KEYDT Variable to get current system date and if u want to calculate difference you need to creat offset between system date and your time characteristic.

regards

raja

[Former Member]

Hi Raja

I'm using a retail specific cube (0RT_C01) and the time characteristic i use is 0CALDAY.

i want to find the current syatem date based on 0CALDAY. I WANT THE RESULT FORMAT OF THE SYSTEM DATE TO BE IN DD.MM.YYYY format.

From

Manesh

[Former Member]

Hi ,

ccheck this....

http://www.sd-solutions.com/documents/SDS_BW_Replacement%20Path%20Variables.html

https://websmp106.sap-ag.de/~sapdownload/011000358700001963972003E/HowToCalcWithAttr.pdf

check with this function module

DATE_CONVERT_TO_FACTORYDATE

Regards,

Vijay.