Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. Query for transactions does not include known transactions from end date

    Query for transactions does not include known transactions from end date

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Voyager

    Problem Symptoms:
    * Known items with end date range not captured by report
    * Extending end date by one day captures items

    Cause:
    Microsoft Access uses 00:00:00 as time for end date, capturing only first minute of date in transactions.

    Resolution:
    Option 1: If appropriate, include time in date specification (mm/dd/yyyy hh:mm:ss) in query.
    Option 2: Extend end date by one day.

    Category: Prepackaged Rpts - Voyager

    Subject: Voyager


    • Article last edited: 8/16/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Quebec" misspelled in Country.cfg
      • Query on ITEM_STATUS_TABLE returns "does not exist"
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      1. contype:kba
      2. Prepackaged Rpts - Voyager
      3. Prod:Voyager
      4. Type:General
      5. Voyager
    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