Insert date and time wildcards

For more information on wildcards, see About Date and Time Wildcards.

To use date and time wildcards:

1. On the Historian tab, in the Options group, click Options.

2. Configure the report to use wildcards and set the base date and base time. For more information, see Configuring Report Options.

3. On the Historian tab, in the Edit Reports group, click Insert Query.

4. In the Query window, type the SQL query or use the Query client to build the query. For more information, see AVEVA Historian Client Query.

5. Click OK. The Additional Time Options dialog box appears.

6. In the Wildcards for time area, configure which time is substituted for the base time in the query.

   • (list box): A base time for the query.

   • Time specified in Report Options: The time specified in the report options is used as the base time for the query. For more information, see Configuring Report Options.

7. Click OK.

   The wildcards are inserted into the query for the date/time parameters and then updated with the appropriate date/time when the report document is run.