Verify the Date/Time format in Microsoft Excel

When you query the database for history values, you must specify the time range for the query. If you choose to use specific dates, you must make sure that the date/time format that you specify match the Microsoft Excel date/time format settings for the result cells.

To verify the date/time format:

1. In the spreadsheet, select the cells to contain the time stamps for the returned data.

2. On the Home tab, in the Cells group, click Format menu, and then click Format Cells. The Format Cells dialog box appears.

3. Click the Number tab.

4. In the Category window, click Date.

5. In the Type list, verify the date format.

6. Click OK.