This website is not affiliated with, sponsored by, or approved by SAP AG.

Difference between 2 dates in BEX query

Business Warehouse

Moderators: Snowy, thx4allthefish

Difference between 2 dates in BEX query

Postby BGE_George » Thu Nov 01, 2012 5:21 am

Hi Sapiens

I have implemented a simple formula variable to calculate difference between 2 dates(D1 and D2) in BEX using replacement path formula varibles for each date D1 and D2

Difference = Formula Var ( D1) - Formula Var ( D2)

The simple formula works when both dates are filled but it doesn't when D2 is not filled. Any ideas how to ehance this formula to check for blank D2?
Still learning...... Will it ever stop ?
SAP Njoi !!
BGE_George
 
Posts: 310
Joined: Thu Mar 10, 2005 4:15 am
Location: United Kingdom

Re: Difference between 2 dates in BEX query[Resolved]

Postby BGE_George » Wed Nov 21, 2012 10:14 am

Thanks to Google.
Still learning...... Will it ever stop ?
SAP Njoi !!
BGE_George
 
Posts: 310
Joined: Thu Mar 10, 2005 4:15 am
Location: United Kingdom


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 4 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.