When you specify a date field in DOCUMENTS, you can either specify your own date format or leave the format area blank. If you leave it blank, the system uses these settings (DateFormat1, DateFormat2, etc.) when searching for date fields.
Use a separate DateFormat setting for each date format to look for. DOCUMENTS comes to this list and tries to match the interpreted value with one of the date formats.
If the program cannot match the value with any of the date format suggestions, the value is presented with the first format suggestion in the list.
Use any combination of these:
D or DD.
D is the day written with one or two digits, 1-31.
DD is the day written with two digits, 01-31.
M, MM, MMM or MMMM.
M is the month written with one or two digits (1-9, 10, 11, or 12).
MM is the month written with two digits (01-12).
MMM is the three-letter abbreviated form of the month (JAN, FEB, etc.).
MMMM is the long month name, controlled by the [FullMonthName] section in Eiglobal.ini. Warning: Do not specify more than four M’s.
The three-letter abbreviated form of the month (MMM) is controlled by the [ThreeCharMonthName] section in Eiglobal.ini.
The Language setting for the date field helps the program to find the right language in the [FullMonthName] and/or [ThreeCharMonthName] sections.
Y, YY or YYYY.
Y is the year written with one or two digits, 8, 98 … (the tens digit may be omitted for the years 2000-2009).
YY is the year written with two digits, for example 09.
YYY is the year written with four digits, for example 2009.
Do not use separator characters such as hyphens or slashes that may be present in the date. These are not invalid, but they are unnecessary since the system finds them even if they are not specified. In addition, there is no need to waste DateFormat settings on them (see limitations below).
The order in which you specify the formats does not matter.
DateFormat1=DDMMYYYY
DateFormat2=MMMMDDYYYY
DateFormat3=MMDDYY
DOCUMENTS stops reading date formats in Eiglobalextra.ini if an empty setting is found. Example:
DateFormat1=DDMMYYYY
DateFormat2= / The program stops reading here and does not see DateFormat3.
DateFormat3=MMDDYY
If empty settings are the last ones listed, then it is ok.
Only the first ten DateFormat settings are used by Invoice Interpret. This is for the sake of performance. You should have the most common date formats listed in the first ten settings.
Only the first twenty DateFormat settings are used by Invoice Verify.