Need to Fetch data between 2 dates
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