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. Community Knowledge
    4. Concatenate Date and Time Fields in ISO 8601 Format

    Concatenate Date and Time Fields in ISO 8601 Format

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    Created By: Igelu-Eluna Analytics
    Created on: 4/29/2020



    Formula

    TO_DATETIME(CAST("Loan Date"."Loan Date" as CHAR)||' '||CAST("Loan Date"."Loan Time" as CHAR), 'dd-mon-yy hh:mi:ss')

    Column Properties > Data Format = Custom, and

    yyyy/MM/ddTHH:mm:ssZ 
     


    IGeLU-ELUNA Analytics Working Group / Analytics Working Group Listserv




    Report
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Analytics Evidence CN9 - Copy Quantity Reporting
      • Converting metadata from Equella to Alma-Digital (a DC to MARC crosswalk)
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      How To
      Content Type
      Documentation
      Product
      Alma
    2. Tags
      This page has no tags.
    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