Reading date data when input formats for dates are specified

You can configure formats for input text data to match your input files. Information in this section applies when you specify input date formats in the Options tab. If you configure this field, if date data does not match the input format, an error occurs. Unless you configure this field, DataMagic automatically evaluates date data in the input data.

When you double-click a field or the Edit icon, a screen appears and prompts you to set input formats for dates. Either select input formats from the samples, or manually enter date formats. You can specify up to 10 input formats for dates.

The following table provides a list of input formats:

Table 4.22 List of Input Formats
#	Character strings	Description
1	YYYY	Western calendar year (four digits)
2	YY	Western calendar year (last two digits) Note that the year is assumed to be in the 2000s. For example, if YY is 14, the year is 2014.
3	RR	Western calendar year (last two digits) If the value is 69 or larger, the year is assumed to be in the 1900s. If the value is 68 or smaller, the year is assumed to be in the 2000s.
4	EYY	Abbreviated form of Japanese era name and Japanese calendar year (00 to 99) (for example, T09 or S25)
5	EEYY	Japanese era name and Japanese calendar year (00 to 99) (for example, 大正09 or 昭和25)
6	eyy	Abbreviated form of Japanese era name and Japanese calendar year (0 to 99) (for example, T9 or S25)
7	eeyy	Japanese era name and Japanese calendar year (0 to 99) (for example, 大正9 or 昭和25)
8	MM	Month (01 to12)
9	mm	month (1 to 12)
10	DD	Day (01 to 31)
11	dd	day (1 to 31)
12	HH or HH24	Hour (00 to 23)
13	hh or hh24	hour (0 to 23)
14	HH12	Hour (01 to 12)
15	hh12	hour (1 to 12)
16	MI	Minute (00 to 59)
17	mi	minute (0 to 59)
18	SS	Second (00 to 59)
19	ss	second (0 to 59)
20	MON	English abbreviation of a month. All uppercase (for example, JAN).
21	Mon	English abbreviation of a month. Initial letter uppercase (for example, Jan).
22	mon	English abbreviation of a month. All lowercase (for example, jan).
23	MONTH	English name of month. All uppercase (for example, JANUARY).
24	Month	English name of month. Initial letter uppercase (for example, January).
25	month	English name of month. All lowercase (for example, january).
26	AM	AM: morning or PM: afternoon
27	Am	Am: morning or Pm: afternoon
28	am	am: morning or pm: afternoon
29	A.M.	A.M.: morning or P.M.: afternoon
30	a.m.	a.m.: morning or p.m.: afternoon

= Remarks =

The behavior of the carry operation is the same as in (2) Carries to the upper unit of time in the Reading date data in the format determined automatically by DataMagic.
If you specify delimiters, you can use character strings that are not listed in the above table.
For DataMagic to support a Japanese era name that is more recent than 平成, it is necessary to specify the new Japanese era name in the Japanese era name (era_name) field of the system environment settings file (huledenv.conf).