#time wildcard

The #time wildcard is used to represent the current date (today) in the query. The use of this wildcard allows you to run the report document on any day and retrieve the data for the same time period.

For example, the WHERE clause for a query for the last eight hours of today's data, starting at 17:00 is as follows:

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

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

The time specification for the query is indicated in the parentheses.

The valid duration units for the time offset are:

• s = seconds

• mi = minutes

• h = hours

• d = days

• w = weeks

• mm = months