Create a Prompt That Doesn't Affect the Query in Launch Pad


Follow the instructions to create a prompt that doesn't affect the data returned in a query. This prompt can be used in formulas in your report.

Add a pair of conditions for a single field (not already in the conditions) to your query.

  1. Where one is for equal to and the other for not equal to.
  2. Set both conditions to the same value a.
  3. Nest them with an OR operation.
    Two Conditions Nested with Or on Business Objects
  4. This creates a pair of conditions that have no impact on the data returned; the field will always be equal to or not equal to any prompt value you enter. You can now use the prompt in formulas, reformatting it to a date (use the todate() function) or number (use the tonumber() function) if needed.

Example:

=DaysBetween(<Fin Rpt File Dt> ; ToDate( UserResponse ("test date") ;"mm/dd/yy") )