DateFormatCSVs
A list of date formats that IDOL Server must be able to read from documents. Separate multiple date formats with commas. There must be no space before or after a comma.
You can use the following values:
-
AUTNDATE. The IDOL date format (1 to a maximum of 10 digits). This format covers the epoch range (1 January 1970 to 19 January 2038) to a resolution of one second, and dates between 30 October 1093 BC and 26 October 3058 to a resolution of one minute. Dates outside this range are stored with values that allow IDOL Server to sort them correctly. You can convert another date to itsAUTNDATErepresentation by using the DateConvert action.NOTE: Micro Focus recommends that you use one of the verbose date formats if you want to use dates outside the normal epoch.
-
#ISODATETIME. An ISO-8601 date, optionally with a time. This format accepts the formatYYYY-MM-DDTHH:NN:SS.FFFFZ.YYYY-MM-DDis always required, but this format also accepts the following variations:- The year can have a plus (+) or minus (-) sign at the start. A plus sign (+) represents AD/CE years, and a minus sign (-) represents BC/BCE years.
- The time is optional, and can be to hour, minute, second, or fractional section precision.
- The date and time can be separated by a
Tor a space, or you can omit the separator between date and time. If you use theTseparator, it must have a valid time after it. - The time zone is optional. If you include a time zone, you can use
Z,±HH,±HHMM, or±HH:MM. - You can omit the separators in both the date and time (that is,
YYYYMMDDHHMMSS, but notYYYYMMDDHH:MM:SSorYYYY-MM-DDHHMMSS).
-
a string that contains one or more of the date formats in the following table.
YYYear (two digits). For example, 99, 00, 01, and so on. YYYYYear (four digits). For example, 1999, 2000, 2001, and so on. #YY+Year (two or four digits). If you provide two digits, it uses the
YYformat. If you provide four digits, it uses theYYYYformat.For example, it interprets
07as2007 ADand1007as1007 AD.#YYear (one to a maximum of 16 digits), optionally followed by ADorBC. An apostrophe (') immediately before the year denotes a truncated year. For example,2008,'97(interpreted as1997),97(interpreted as97 AD),'08(interpreted as2008),2008 AD, and200 BC. A truncated year with a BC identifier is not valid ('08 BC).#FULLYEARYear (one to a maximum of 16 digits). For example, 8,98,108,2008, each of which is taken literally. The year is taken relative to the common EPOCH (0 AD).#ADBCTime period. For example,
AD,CE,BC,BCE, or any predefined list of EPOCH indicators. Typically, the year specified in the above formats is interpreted as untruncated and relative to the EPOCH. For example, 84 AD is interpreted as 1984 AD, and 84 BC is interpreted as 84 BC.The only exception to this is when you use both
#YY+and#ADBC. In this case, the format is interpreted as untruncated, even if the year was set to truncated by#YY+. For example, 99 AD is interpreted as the year 99 AD.Micro Focus recommends that you use only
YY,YYYY, or#FULLYEARwith#ADBC.LONGMONTHA long month, for example, January,February, and so on.SHORTMONTHA short month, for example, Jan,Feb, and so on.MMMonth (two digits). For example, 01,10,12, and so on.M+Month (one or two digits). For example, 1,2,3,10, and so on.DDDay (two digits). For example, 01,02,03,12,23, and so on.D+Day (one or two digits). For example, 1,2,12,13,31, and so on.LONGDAYTwo digits with a postfix. For example, 1st,2nd, and so on.HHHour (two digits). For example, 01,12,13, and so on.H+Hour (one or two digits). NNMinute (two digits). N+Minute (one or two digits). SSSecond (two digits). S+Second (one or two digits). ZZZTime zone, for example, GMT,EST,PST, and so on.ZZZZZTime difference (one to nine digits). For example, +04denotes four hours ahead of UTC. Other examples include+4,+04,+0400,+0400 MSD(the stringMSDis ignored). A further example is+030. In this case the time difference is interpreted as 30 minutes.
This option accepts a singleZcharacter in a date string as UTC. It accepts time zones between-1300and+1500.#PMAn AMorPMindicator (two characters). For example,2001/09/09 02:46:40 PM.#SA space.
Notes
-
Specify formats in order of length (starting with the longest). IDOL Server matches format strings in the order in which you list them. If you list a shorter format first, IDOL Server might match against an incorrect format, for example, matching
19/10/2002asDD/MM/YYand indexing the document with the date19/10/20. -
Separate multiple formats with commas. There must be no space before or after a comma. To specify a format that contains a space, put the format in quotation marks.
-
When the document field contains a partial date, IDOL Server assigns the document a metadata field with a full date.
-
If the day is not specified, the date is the first day of the specified month.
-
If neither the day or month are specified, the date is the first of January in the specified year.
-
Partial dates are indexed only if they are listed in DateFormatCSVs.
| Type: | String |
| Default: | YYYY/MM/DD
|
| Required: | No |
| Configuration Section: | Server |
| Example: | DateFormatCSVs=D+/SHORTMONTH/YYYY,DDMMYY
In this example, only document dates with the format D+/SHORTMONTH/YYYY (for example, 2/Jan/2001) or DDMMYY (for example, 020101) can be indexed with a date.DateFormatCSVs="D+SHORTMONTH YYYY","Date: D+ LONGMONTH, YYYY"In this example, only document dates with the format D+ SHORTMONTH YYYY (for example, 2 Jan 2001) or Date: D+ LONGMONTH, YYYY (for example, Date: 2 January, 2001) can be indexed with a date.DateFormatCSVs=LONGMONTH/D+/#Y H+:N+:S+In this example, only document dates with the format LONGMONTH/D+/#Y H+:N+:S+ (for example, September/9/2001 AD 2:46:40 or September/9/2001 2:46:40 or September/9/'01 2:46:40 or September/9/'01 AD 2:46:40) can be indexed with a date.DateFormatCSVs=LONGMONTH/D+/#FULLYEAR #ADBC H+:N+:S+In this example, only document dates with the format LONGMONTH/D+/#FULLYEAR #ADBC H+:N+:S+ (for example, September/9/8 AD 2:46:40 or September/9/2008 AD 2:46:40 or September/9/'01 2:46:40 or September/9/'01 AD 2:46:40) can be indexed with a date.DateFormatCSVs=D+ LONGMONTH YYYY HH:NN:SS ZZZZZIn this example, only document dates with the format D+ LONGMONTH YYYY HH:NN:SS ZZZZZ (for example, 17 May 2003 10:41:07 -0400) can be indexed with a date. |
| See Also: |