A list of date formats that IDOL Content Component 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 HPE 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 Content Component to sort them correctly. You can convert another date to its AUTNDATE
representation by using the DateConvert action.
Note: HPE recommends that you use one of the verbose date formats if you want to use dates outside the normal epoch.
a string that contains one or more of the following:
YY
|
Year (two digits). For example, 99, 00, 01, and so on. |
YYYY
|
Year (four digits). For example, 1999, 2000, 2001, and so on. |
#YY+
|
Year (two or four digits). If you provide two digits, it uses the For example, it interprets |
#Y
|
Year (one to a maximum of 16 digits), optionally followed by AD or BC . An apostrophe (' ) immediately before the year denotes a truncated year. For example, 2008 , '97 (interpreted as 1997 ), 97 (interpreted as 97 AD ), '08 (interpreted as 2008 ), 2008 AD , and 200 BC . A truncated year with a BC identifier is not valid ('08 BC ). |
#FULLYEAR
|
Year (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). |
#ADBC
|
Time period. For example, The only exception to this is when you use both HPE recommends that you use only |
LONGMONTH
|
A long month, for example, January , February , and so on. |
SHORTMONTH
|
A short month, for example, Jan , Feb , and so on. |
MM
|
Month (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. |
DD
|
Day (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. |
LONGDAY
|
Two digits with a postfix. For example, 1st , 2nd , and so on. |
HH
|
Hour (two digits). For example, 01 , 12 , 13 , and so on. |
H+
|
Hour (one or two digits). |
NN
|
Minute (two digits). |
N+
|
Minute (one or two digits). |
SS
|
Second (two digits). |
S+
|
Second (one or two digits). |
F
|
Milliseconds (one digit). |
FF
|
Milliseconds (two digits). |
FFF
|
Milliseconds (three digits). |
F+
|
Milliseconds (one to three digits). |
ZZZ
|
Time zone, for example, GMT , EST , PST , and so on. |
ZZZZZ
|
Time difference (one to nine digits). For example, +04 denotes four hours ahead of UTC. Other examples include +4 , +04 , +0400 , +0400 MSD (the string MSD is ignored). A further example is +030 . In this case the time difference is interpreted as 30 minutes. |
#PM
|
An AM or PM indicator (two characters). For example, 2001/09/09 02:46:40 PM . |
#S
|
A space. |
Notes
Specify formats in order of length (starting with the longest). IDOL Content Component matches format strings in the order in which you list them. If you list a shorter format first, IDOL Content Component might match against an incorrect format, for example, matching 19/10/2002
as DD/MM/YY
and indexing the document with the date 19/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 Content Component 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 DateFormatCSVs="D+SHORTMONTH YYYY","Date: D+ LONGMONTH, YYYY" In this example, only document dates with the format DateFormatCSVs=LONGMONTH/D+/#Y H+:N+:S+ In this example, only document dates with the format DateFormatCSVs=LONGMONTH/D+/#FULLYEAR #ADBC H+:N+:S+ In this example, only document dates with the format DateFormatCSVs=D+ LONGMONTH YYYY HH:NN:SS ZZZZZ In this example, only document dates with the format |
See Also: |
|