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:
- Instructions for Client Center users
- Instructions for Intota users
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.
* * 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