Configure a Date Billboard Parameter

Date parameters enable selection of a time and a specific, relative or fixed date, or a shift. Specific date examples: Day 1 of Current Month, Quarter 2 of Previous Year. Relative date examples: Yesterday, Last Day of Previous Month, Previous 2 Days, First Day of Next Month.

Copy

Example: Return despatch orders with a planned despatch date within a specified date range, but ignore times in the {Start} and {End} parameters.

select DespatchOrderID 'ID', 
    Name 'Despatch Order Name'
from DespatchOrder
where convert(varchar(10), PlannedDespatchDate, 120) >= convert(varchar(10), {Start}, 120)
    and convert(varchar(10), PlannedDespatchDate, 120) <= convert(varchar(10), {End}, 120)

Security Note: You need the Allow billboard maintenance security right in the Billboards domain security rights group for this activity.

Activity Steps

  1. Open the Billboard (configuration).
  2. Select the Parameters tab.
  3. Right-click in the Parameters field group and select New » Date Parameter from the menu.
  4. Complete the following fields.
    • Name—Case-sensitive name of the parameter that is used in the query.
    • Caption—Caption used when prompting for the parameter value.
    • Required—Whether the parameter must be defined before data can be retrieved.
    • Force Refresh—Whether the parameter is refreshed if its value is dynamic.
    • Default Value—Default value of the parameter, used to display a preview of the SQL query.
  5. Click Save.