#date wildcard

The #date wildcard is used to represent a specific date in the query. This wildcard is similar to the #time wildcard. The #time wildcard is a placeholder for the current date, and the #date wildcard is a placeholder for a specific date.

For example:

WHERE DateTime >= '#date(17:0:0)-8h'

AND DateTime <= '#date(17:0:0)'

The WHERE clause indicates to use the last eight hours of data, starting at 17:00, for the date that is specified by the Report Date option in the Report Options dialog box. For more information, see Configuring Report Options.

The time specification for the query is specified within parenthesis.

The valid duration units for the time offset are:

• s = seconds

• mi = minutes

• h = hours

• d = days

• w = weeks

• mm = months