Date formats are used to specify the format of data in the import file that is used to populate the Date Keywords associated with the documents imported via the process format.
To configure a date format:
- Select the field order mapping to be configured. If the Keyword Type that is part of the field order mapping is a Currency or Date Keyword, the Format button is enabled.
-
Click Format. The Date Format dialog box is displayed:
-
In the Order section, select the radio button that specifies how the order that the month, day, and year are presented in the import file, where M represents Month, D represents Day, and Y represents Year.
If your import file contains date values that cannot be described by these options, select the Locale Specific Date check box to use your operating system's locale. For this option to function correctly, the language selected in the Language drop-down must match the language selected in the workstation's Regional Settings.
-
In the Month Settings section, select the radio button that specifies how the month value of the date is presented in the import file.
-
Numeric. Select this radio button if the month is represented by a number (e.g., January = 1). If the month value is always represented by two digits (e.g., January = 01), select the Month Leading Zero check box.
-
Three Letter Months. Select this radio button if the month is represented as an uppercase, three-letter abbreviation (e.g., JAN, FEB, MAR).
-
Full Month —Select this radio button if the month is spelled out in its entirety (e.g., January, February, March).
-
-
Enter the character used to separate Month, Day and Year values in the Separator field.
A forward slash (/) is commonly used as a date separator. A space ( ) is also a valid separator value.
- Select the Day Leading Zero check box if all days are represented by two digits. Days 1-9 are preceded by zeroes. (e.g., the first day of the month=01).
- Select the Century check box if the year value consists of four digits instead of two (i.e., 1990 vs. 90).
-
Use the Language drop-down list to select the language in which the date is written so that OnBase can translate the value into a format it is able to recognize.
Only languages currently supported by OnBase are displayed. For more information on languages supported by OnBase, contact your solution provider.Note:
For some Japanese dates, a preprocessor must be used to translate the dates into OnBase-supported characters.
Note:If you have selected the Local Specific Date option, the language selected in the Language drop-down must match the language selected in the workstation's Regional Settings.
- Click Save.