Server and Capture date are incorrectly formatted when opening downloaded data

If you download your .csv file the dates under ServerDate and CaptureDate are incorrect do the following.

Note: the data is correct, it just had the incorrect formatting applied in Excel

  1. Open the .csv file in Microsoft Excel
  2. Select Column A and Column B (ServerDate and CaptureDate)
  3. Right click on the highlighted cells and select Format Cells
  4. Select Date from the Category
  5. Select the following formatting - 3/14/12 1:30PM
  6. Click ok to close the dialog box

The cells will now be correctly formatted with the Date and Time.