Date parameter
Last updated
Was this helpful?
Last updated
Was this helpful?
Date Parameters define a default data range to be used in your query, with the start date and end date as placeholders. These parameters are always used in pairs, representing the start and end of a selected time period.
When creating a Date Parameter, you'll need to configure:
Set the default start and end dates that will be pre-filled in the calendar. These do not restrict what users can select—users can adjust the dates freely.
Display name: The name that will appear in the control UI.
SQL name(s): The name to be used in the SQL query to be replaced by the starting and ending date of the selected period.
After creating the parameter, add it manually to your SQL query using its placeholders:
Once added, the date picker will appear int he right-side panel, allowing users to adjust the range and see the data source update in real time.