Enter dates

Find guidelines for entering dates and formatting rules for date data fields.

Enter dates in the Item Editing tab, the Project Spreadsheet, or the Metadata Templates. Dates can also be entered in a tab-delimited text file. Your administrator may choose to configure the date field as a Date data type to keep the integrity of the date format to support accurate sorting and date range searching. If this has been configured in the collection field properties, there are some guidelines and formatting rules for entering dates.

 Note:  A Search by Date option is available on the Advanced Search pane if one or more collections contain a searchable date data type field.

Checking Date type

When setting field properties for a collection, the administrator may choose to set the Date field as a Date type.

To check if your Date field has a Date type:

Guidelines for entering dates

Month values must be between 1 and 12.

 Note: Data type text metadata fields have fewer formatting restrictions than data type date metadata fields. When a field is updated from text to date data type, the formatting of values in these fields might be considered improperly formatted. In Project Client, the YYYY-YYYY range formatting will be automatically converted to a list of semi-colon delimited YYYY values. In CONTENTdm Administration, a pop-up will result when saving the metadata in an object that contains an unsupported format. The metadata will need to up updated manually. Object metadata can be updated either in CONTENTdm Administration or by importing the object into Project Client.

Formatting rules

When importing dates to a Date data type field, they must be valid dates in the following supported formats:

Supported Formats YYYY-MM-DD
YYYY-MM
YYYY
MM/DD/YYYY
MM/YYYY
YYYY-YYYY
2009-01-01
2009-01
2009
11/30/2008
11/2008
2008-2009
Supported delimiters between dates Comma (,) and
semicolon (;)
2008, 2009
2008; 2009
Leading spaces are okay but not required when using multiple dates YYYY; YYYY; YYYY
YYYY;YYYY;YYYY
2007; 2008; 2009
2007;2008;2009

After dates are added to the Project Spreadsheet, they will be displayed in a yyyy-mm-dd format.