Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Alma

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Alma
    3. Knowledge Articles
    4. How to fix Analytics report to export date correctly to Excel 2007+

    How to fix Analytics report to export date correctly to Excel 2007+

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question

     

    • Product: Alma
    • Product Version: February 2016
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Question

    When exporting a report to Excel 2007+, workbook opens but some data is not correct.

    Dates are shown as numbers

     

    bad dates.png

     

    Answer

     

    Days fields where probably overriden by default date format to custom: [FMT:date]
    this the reason the report can’t export to excel 2007 in good format.

     

     

    bad dates 1.png

     

    The default date format is ‘Local Short Date 6/8/2003’

     

     

    bad dates 2.png

     

    Please go to all date fields in criteria, right click and select ‘Column Properties’.

    Choose ‘Data Format’ tab  in the open window and change Date Format to ‘Local Short Date 6/8/2003’. Repeat this for all date fields in this report. That should solve the error.

     

     

    • Article last edited: 22-Feb-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Link resolving to journals that changed title/ISSN
      • Scheduled reports and scheduled dashboards constantly failing
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Documentation
      Language
      English
      Product
      Alma
    2. Tags
      1. Analytics
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved