Skip to Content

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

Using formula in selection parameters

Hi,

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:

totext({APPROPRIATION_TRACKING.APPR_MM},"0#") & "-" & totext({APPROPRIATION_TRACKING.APPR_DD},"0#") & "-" & totext({APPROPRIATION_TRACKING.APPR_CCYY},"####")

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

Former Member
replied

Try creating a formula like this

@Date:

date(tonumber(),tonumber(),tonumber())

Now create a static date parameter with option allow range values

Now in the record selection write the condition like this

@Date={?DateParameter}

Hope this helps!

Raghavendra

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