Set the base date and base time parameters

The base date and time parameters can be used within the history and aggregate functions instead of actual dates/times. The base date and time are stored with the current workbook and affect only the active workbook.

By using these parameters, you can create generic reports that accommodate any date/time; change the base date and base time for the workbook.

To set the base date and time:

1. On the Historian tab, in the Publish group, click Options, and then click Set Base Date/Time. The Set Base Date/Time dialog box appears.

2. In the Base date list, configure the base date.

3. If you want to insert the wwBaseDate() function in a cell, select the Insert wwBaseDate() function in selected cell check box and specify location of the worksheet cell(s) that will contain the output. Click on the button to select the cell(s) using your mouse. For more information, see Selecting Cells.

4. In the Base time list, configure the base time.

5. If you want to insert the wwBaseTime() function in a cell, select the Insert wwBaseTime() function in selected cell check box and specify location of the worksheet cell(s) that will contain the output. Click on the button to select the cell(s) using your mouse. For more information, see Selecting Cells.

6. Click OK. You are prompted to confirm the base date and base time.

7. Click OK. If you selected to insert the base date and/or base time, they appear in the spreadsheet.