1,126
edits
Difference between revisions of "Date and Time formats in Content Manager OnDemand"
Jump to navigation
Jump to search
m
Date and Time formats in Content Manager OnDemand (view source)
Revision as of 14:05, 19 October 2020
, 14:05, 19 October 2020Minor updates to CMOD Date formats.
m (Updated CMOD Folder Date formats.) |
m (Minor updates to CMOD Date formats.) |
||
| Line 23: | Line 23: | ||
: Before database engines offered native date and time formats, dates were represented as an integer inside the database. | : Before database engines offered native date and time formats, dates were represented as an integer inside the database. | ||
: A date of zero represented January 1st, 1970 - and 1 for January 2nd, 1970, and so on. August 20th, 2016 is day number 17034. | : A date of zero represented January 1st, 1970 - and 1 for January 2nd, 1970, and so on. August 20th, 2016 is day number 17034. | ||
: It was NOT possible to represent dates prior to 1970, or after | : The supported date range was from January 1st 1970 to December 31st 2058, due to being stored internally as an integer. | ||
: It was NOT possible to represent dates prior to 1970, or after 2058 with a date field in Content Manager OnDemand before v9.0. | |||
; Date & Time (old Style) | ; Date & Time (old Style) | ||
| Line 31: | Line 32: | ||
=== Application Date Formats === | === Application Date Formats === | ||
In order to load documents into Content Manager OnDemand, an Application definition must be configured, defining the format and locations and formats of metadata found in the documents (or the index file if one exists). In the Application configuration window, in the "Load Information" tab, you can select a date or date / time format | In order to load documents into Content Manager OnDemand, an Application definition must be configured, defining the format and locations and formats of metadata found in the documents (or the index file if one exists). In the Application configuration window, in the "Load Information" tab, you can select a date or date / time format from the list called "Application Group Database Name", then enter the date (and/or time) format on the right hand side of the tab in the 'Format' field. | ||
This allows an Application to be configured to parse almost any existing date format, so it can be converted into the date field type defined at the Application Group level, and stored in the database. | This allows an Application to be configured to parse almost any existing date format, so it can be converted into the date field type defined at the Application Group level, and stored in the database. | ||
The range of available variables for Applications can be found in the online help - search the online help for the phrase "Date and Time Formats". | |||
=== Folder Date Formats === | === Folder Date Formats === | ||