DateFormatCSVs
 
Type

String

Default

YYYY/MM/DD

Required

no

Configuration section

[Server]

Description

List of supported date formats. One or more date formats that you want IDOL server to be able to read from the files that it contains. If you want to enter multiple date formats, you must separate them with commas (there must be no space before or after a comma). You can enter one of the following:

  • AUTNDATE
  • a string that contains one or more of the following:
YY

Year (2 digits). For example, 99, 00, 01 and so on.

YYYY

Year (4 digits). For example, 1999, 2000, 2001 and so on.

#YY+

Year (2 or 4 digits). If 2 digits are provided, then the YY format is used. If 4 digits are provided, then the YYYY format is used. For example, 07 is interpreted as 2007 AD and 1007 is interpreted as 1007 AD.

#Y

Year (1 to a maximum of 16 digits) and may be 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 invalid ('08 BC).

#FULLYEAR

Year (1 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 (0AD).

#ADBC

Time Period. For example, AD, CD, BC, BCE or any predefined list of EPOCH indicators. Typically, the year specified using the above Year 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 #YY+ and #ADBC are both used. 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.

It is recommended you only use YY, YYYY or #FULLYEAR with #ADBC.

LONGMONTH

A long month, for example, January, February and so on.

SHORTMONTH  

A short month, for example, Jan, Feb and so on.

MM

Month (2 digits). For example, 01, 10, 12 and so on.

M+

Month (1 or 2 digits). For example, 1,2,3,10 and so on.

DD

Day (2 digits). For example, 01, 02, 03, 12, 23 and so on.

D+

Day (1 or 2 digits). For example, 1, 2, 12, 13, 31 and so on.

LONGDAY

2 digits with a postfix. For example, 1st, 2nd and so on.

HH

Hour (2 digits). For example, 01, 12, 13 and so on.

H+

Hour (1 or 2 digits).

NN

Minute (2 digits).

N+

Minute (1 or 2 digits).

SS

Second (2 digits).

S+

Second (1 or 2 digits).

ZZZ

Time Zone, for example, GMT, EST, PST, and so on.

ZZZZZ

Time Difference (1 to 9 digits). For example, +04 denotes 4 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 differences is interpreted as 30 minutes.

#PM

AM or PM indicator (2 characters). For example, 2001/09/09 02:46:40 pm

#S

A space.

Note:

Format strings are matched in the order in which they are listed. You should therefore put the format in order of length (starting with the longest). This prevents the matching of, for example, 19/10/2002 with DD/MM/YY (if this format has been listed before DD/MM/YYYY) and the document from being indexed with the date 19/10/20.

To enter one or more formats, separate them 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.

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 ZZZZZ

In 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.