Date Range Querying Parameters

Parameters are normally supplied from selected columns of the parent data table, or from action controls.

Date range querying parameters act like userid such that they will be auto completed and their values can be used in data queries to restrict data sets to the redefined time ranges such as the following:

  • $CurrentTime – Returns the Date/Time of the current time

  • $LastWorkDay – Returns the last business date (excludes Saturdays and Sundays)

  • $WeekStart – Returns the date of the most recent Monday

  • $QuarterStart – Returns the date of the most recent start/first day of the quarter period (i.e., 1st January, 1st April, 1st July, 1st October)