Report fields regarding time display a date when exported to Excel

There are some report fields that show the time something happened, but these values appear as a date when exported to Excel. The fields display correctly as a time when displayed on screen, in PDF, or CSV.

Article Number: 106000

Products:

  • eTapestry
The following fields in reports behave this way:
  • Creation Time
  • Last Modified Time
  • Creation Time
  • End Time
  • Last Modified Time
  • Start Time
  • Current Time
There are a couple different ways to display these fields as a time instead of date.
  1. Export as CSV (or PDF) instead of Excel
  2. If you must export as Excel, you can reformat the column following these steps:
    • Highlight the column
    • Right click > Format cells
    • On the Number tab, choose Time > OK

Environment

 eTapestry

Was this article helpful?

Blackbaud Community

Connect and collaborate with fellow Blackbaud users.

Chat with Support

Chat with our experienced staff to receive help right away.

Connect

The Blackbaud team is online and ready to connect with you!