#ReportTime wildcard

The #ReportTime wildcard is used to represent the report time in the query. This wildcard can be used with the #time and #date wildcards.

For example:

WHERE DateTime >= '#time(#ReportTime)-8h'

AND DateTime <= '#time(#ReportTime)'

This WHERE clause indicates to use the last eight hours of data, for today's date, for the time that is specified by the Report Time option in the Report Options dialog box.

Another example is:

WHERE DateTime >= '#date(#ReportTime)-8h'

AND DateTime <= '#date(#ReportTime)'

This WHERE clause indicates to use the last eight hours of data for the date and time specified by the Report Date and Report Time options, respectively, in the Report Options dialog box. For more information, see Configuring Report Options.

The valid duration units for the time offset are:

• s = seconds

• mi = minutes

• h = hours

• d = days

• w = weeks

• mm = months