Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need to Fetch data between 2 dates

Dear All,

Requirement : On the Bex selection screen a key date will be entered I need to fetch all those records which are in between start date & end date- Means

Start Date < = Key date=> End date

Start date & end date field exists in Cube, But the Key date does not exists. Key date will be a random date.

Can any one please help me how to achieve this?

Can this be done using virtual Chraracteristis? Not sure if the Virtual Char will be applicable for the date field.

I have tried doing it in the following way.

Create 2 formula KF populate it wilh a formula variable which is of processing type replacement path which takes value from start date & end date Charateristics IO.

I created a formula variable KEYDATE (user entry/ready for input) and created a condition

Start date ( KF) <= Key date

End date (KF)> = Key date

But this does not seem to work.

Can any pls help?

Thanks & Regards

Shree

Not what you were looking for? View more on this topic or Ask a question