My report shows last circulation date as all zeros
Symptom
- I ran a report to show my circulation data. The last circulation date column shows all zeros, not dates
Applies to
- WorldShare Reports
- WorldShare Analytics
- WorldShare Circulation
Resolution
This is a formatting issue within Excel. To correct this, complete the following:
- In Excel, highlight the column
- Right click > Choose Format Cells
- Choose Date
- Under Type Choose 3/14/12 1:30PM
- Click OK
- Save your spreadsheet