Using formula variable (instead of infoobject) as a User Input for date range in BEx Query

[Former Member]

Hi Experts,

We need to create a user input variable for single date range(energy audit period from-to) in Bex Query based on which report output should display data.And this user input variable should not be created from infoobject. We tried implementing this through formula variable but it can only be created for single value option but we want it for interval option(for date range).

Please suggest.

Thanks,

Priya

[Former Member]

Hi Priya,

Create a second formula variable to capture the "To value" of the range. Seeing that you are not restricting any info object (date) with this range, you would probably be using a customer exit to process these variable values. In the customer exit you can use the value from both variables to create a range.

Thanks

Francis