Knowledge Base

Article 13002491

Dates are displaying as time in Excel when viewing Historical Extract


Product: Renaissance Accelerated Reader, Renaissance Star Early Literacy, Renaissance Star Math, Renaissance Star Reading

Platform: Macintosh, Windows

Last Updated: 7/16/2019


This article only applies if your hosted URL begins with 'https://global-zone'. If your hosted URL doesn't begin with 'https://global-zone', reference KB article #11471943 for information on opening and working with Historical Extracts.


Issue:

When double-clicking on the Historical Extract .csv file and opening in Excel, Excel displays only the time component of the dates (00:00:0) included in the extract. 

Reason:

Historical extracts are comma-separated value (.csv) files that can be opened in a spreadsheet program. If you open the Historical Extract in Excel and save without changing the format of the date columns (either Save or Save As), the date columns in the file will only contain minutes, seconds, and milliseconds (00:00:0) going forward. You will need to format the date columns before saving.

NOTE: When opening Historical Extracts in Notepad, Notepad++, importing to Google docs, or importing into Excel (open Excel -> Data tab -> Get Data -> From Text/CSV -> browse to and select the Historical Extract) the dates show correctly. 

Resolution:

Use these steps to format the date columns before saving in Excel.

1. Select the column or columns

2. Right-click on the selected area

3. Choose Format Cells

4. Select Date on the Number tab

5. Choose a date format

6. Click [OK]

7. Save the .csv file
Date columns that need formatting if you want to open in Excel:

  • School Year Start Date
  • School Year End Date
  • Birthdate
  • Activity Completed Date
  • Screening Window Start
  • Screening Window End
  • Window SGP Prior Test 1 Date
  • Window SGP Prior Test 2 Date 


Keywords: 13002491, formatting, ZKBClientServer, ZKBReports, RenaissanceGrowthPlatform

Renaissance Accelerated Reader, Renaissance Star Early Literacy, Renaissance Star Math, Renaissance Star Reading are trademarks of Renaissance Learning, Inc. and its subsidiaries, registered, common law, or pending registration in the United States and other countries.

New Search

© Renaissance Learning. All Rights Reserved. | Privacy Policy | Terms of Use | Site Map

© Renaissance Learning. All Rights Reserved. | Privacy Policy | Terms of Use | Site Map