Relative time option

You can define a query that uses a relative time in the past for the starting date. For example, the last five minutes from the current time.

To set a relative time:

1. In the from list, select the date to use as the start date.

   • Now: Use the current date and time.

   • Today: Use the current date and a time that you specify.

   • Specify date: Use the date and time that you specify.

   • BaseDate: Use the date and time as set by the global base date and time options for the workbook. For more information, see Setting the Base Date and Base Time Parameters.

2. If necessary, specify a date and/or time.

3. In the plus/minus list, select plus to go forward in time or minus to go backward in time, and then set the duration.