Variable possible?

[Former Member]

I have a query that when executed, I want it to bring back data for 0CPR_DATEEND + 45 days. How can I do this?

Thanks!

Angie

[Former Member · Accepted solution]

Hi Angie,

Create a variable and try using Variable offset.

check http://help.sap.com/saphelp_bw33/helpdata/en/3f/89533e5ff4d064e10000000a114084/content.htm

-Doodle

Message was edited by: Doodle

[Former Member · Accepted solution]

I asked the question wrong. I want the query to return all values where 0CPR_DATEEND is between today and today + 45 days.

Angie

[former_member188975 · Accepted solution]

Hi Angie,

You can try this: Restrict this InfoObject by 0DAT variable and instead of single values, make the selection as Value range (Upper left box). Now specify the offset as +45. So this gives you a range between today (from 0DAT) and 45 days ahead.

This solution assuming your InfoObject is a reference object of 0DATE.

Hope this helps...

[Former Member · Accepted solution]

Angie,

This link will explain everything clearly.

http://help.sap.com/saphelp_bw33/helpdata/en/3f/89533e5ff4d064e10000000a114084/content.htm

-Doodle

[former_member188975]

Hi Angie,

Do you have a variable for 0CPR_DATEEND in the query? If yes, then you can use offset to the get the value for 45 days ahead (+45).

Hope this helps...