Skip to Content

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

Using formula in selection parameters


I have a table (APPROPRIATION_TRACKING) that shows payment history. It has separate fields for payment month, day and year, and a field showing the amount paid.

I have created a formula that converts the separate month/day/year fields into a single date:


I want the user to be able to select a date range, and then get payments made in that date range.

But when I am creating the parameter, I don't see the formula in the "Value Field" selection box.

I know this is possible but can't figure it out...any ideas?

thx jon


Try creating a formula like this



Now create a static date parameter with option allow range values

Now in the record selection write the condition like this


Hope this helps!


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