Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    360 Core and Intota: Valid Date Formats

    • Product: 360 Core Client Center

    What are the acceptable date formats for the Client Center and for Intota?

    When customizing coverage dates of databases and journals in the Knowledgebase, the date will be rejected if it isn't in one of the valid date formats listed in the table below.
    There are several special situations to be aware of:
    • Date To cannot be before Date From.
    • Dates can be entered one day in the future. This avoids the problem if you enter today's date and you live in a part of the world where the date is a day later than it is in the U.S. where ProQuest's main office is. Currently you cannot enter a date more than one day in the future.
    • The Offline Date and Status Editor accepts any of these valid date formats.
    • Coverage dates for library-specific holdings (also known as "library-managed holdings") aren't required to follow one of these date formats. However, for libraries with a link resolver (like 360 Link), it is especially important that the coverage dates for the holdings conform to our valid date formats so that the link resolver can recognize the dates and correctly provide links to full-text content.
    • Some date formats are valid for customizing coverage dates for databases but are not valid for customizing individual titles (holdings) within a selectable database (a database in which your library does not subscribe to the complete collection). Such formats are indicated with an asterisk * in the table below. For more information about selectable databases: Client Center users click here; Intota users click here.
      To change the numerical format for dates displayed to patrons, go to the appropriate Administration Console for the service (360 Core or 360 Link), and then select the Custom Text page within the admin console. For 360 Search, go to the Client Center and select Library Settings > Other Settings.
    • If you need to add split coverage dates (more than one date range) to a database or a journal title, use the instructions:

    Fixed Dates

    The preferred format for fixed dates is MM/DD/YYYY (for example, 04/07/2009 for April 7, 2009), but see the tables below for other accepted formats. Only formats in the following tables are accepted, so please let us know if you think a particular format should be supported that is not currently on the list.
    Fixed (Exact) Dates
    Example
    (do not include the asterisk)
    Displays As
    MM/DD/YYYY
    04/09/2007
    04/09/2007
    MM/D/YYYY
    04/9/2007
    04/09/2007
    M/D/YYYY
    4/9/2007
    04/09/2007
    MM-DD-YYYY
    04-09-2007
    04/09/2007
    MM-DD-YY
    04-09-07
    04/09/2007
    MM-D-YYYY
    04-9-2007
    04/09/2007
    M-D-YYYY
    4-9-2007
    04/09/2007
    YYYY
    2007
    01/01/2007 [if used for a Start Date, or 12/31/2007 if used for an End Date]
    DD-MMM-YY*
    09-APR-07
    04/09/2007
    MM.DD.YYYY*
    04.09.2007
    04/09/2007
    MM.DD.YY*
    04.09.07
    04/09/2007
    YYYY-MM-DD*
    2007-04-09
    04/09/2007
    Winter/Spring/Summer/Fall YYYY
    Spring 2007
    Spring 2007 [but system tracks it as 03/21/2007 if used for a Start Date and 06/20/2007 if used for an End Date]
    First/Second/Third/Fourth Quarter YYYY
    Second Quarter 2007
    Second Quarter 2007 [but system tracks it as 04/01/2007 if used for a Start Date and 06/30/2007 if used for an End Date]
    * These date formats are not valid for individual titles (holdings) within a database, but are valid for databases.

    Relative Dates

    Relative dates are those that change based on the day on which they are viewed, which are often used for things like embargos. You can combine relative dates for both start and end dates, such as "last calendar year to present."
    When patrons view the title or database in the E-Journal Portal, they will not see the Result for Start (or End) Date; instead, they'll see the relative date phrase you entered (such as "Last calendar year"). If you'd like the system to display relative dates as calculated calendar dates instead, send us a message with the Support Portal option near the top of this page and we will turn it on for you.
    The following relative date formats are valid:
    Relative Dates
    Example
    (enter exactly as shown here)
    Result for Start Date
    (if viewed or used on Feb. 9, 2010)
    Result for End Date
    (if viewed or used on Feb. 9, 2010)
    Current calendar year
    Current calendar year
    01/01/2010
    12/31/2010
    Last calendar year
    Last calendar year
    01/01/2009
    12/31/2009
    x calendar years ago (x>1)
    2 calendar years ago*
    01/01/2008
    12/31/2008
    1 day/week/month/year ago
    1 month ago*
    01/08/2010
    01/08/2010
    x days/weeks/months/years ago (x>1)
    2 weeks ago*
    01/25/2010
    01/25/2010
    Current month
    Current month
    02/09/2010
    02/09/2010
    Current week
    Current week
    02/08/2010
    02/08/2010
    Present

    Note: The Custom Date To field in the ODSE offline updating tool does not support "Present"; leave the Custom Date To field empty.
    Present
    [do not use "Present" for a Start Date]
    [whatever is the most recent available issue**]
    * Enter a number; do not spell it out. For example, enter 1 month ago, not one month ago.
    * * For various reasons involving publishers, database updates, etc., the "most recent available issue" may not be the most-recent issue of a journal.


    • Date Created: 9-Feb-2014
    • Last Edited Date: 16-Feb-2016
    • Old Article Number: 7149