About date/time formatting

The default formatting for date/time values depends on which version of the Excel API is supported by your installed version of Excel. For more information about specific features supported by different Excel API versions, see Minimum Supported Versions of Microsoft Excel.

• Excel API Version 1.12 (or higher)

  If your version of Excel supports the Excel API version 1.12 or higher, by default date/time values are formatted according to your system's regional settings.

• Excel API Version 1.11 (or lower)

  If your version of Excel supports the Excel API version 1.11 or lower, by default date/time values are formatted according to your system's language setting. AVEVA Historian contains a preset list of appropriate default date/time formats for all supported languages.

Customizing the date/time format

After you have retrieved data using the Single Value, Periodic Numeric, or Time In State task panes, you can apply your own custom date/time format if the default format does not meet your requirements. Date/time values are formatted based on the following rules:

1. If a custom format is applied to the first value in a row or column of date/time values, the same custom format is applied to the rest of the values in the row or column.

2. If no custom format is applied to the first value, or the General format is applied, all date/time values in the row or column use the default format specified above.

To customize the date/time format:

3. Create a report using the Single Value, Periodic Numeric, or Time In State task panes, including one or more date/time fields in the output.

4. Depending whether the tag direction is down or across, the date/time values will be listed in rows or columns.

   Locate the first cell in a row or column containing a date/time value, and apply formatting using Excel's Format Cells dialog.

   

5. Click FINISH on the task pane to refresh your report. The custom date/time format you selected is applied to all date/time values in that row or column.

6. To restore the default date/time format, select the first date/time value in the row or column and apply the General format, then click FINISH to refresh the report. The date/time format for that row or column changes back to the default format.