Data Transformation Engine Type Designer Reference Guide

Chapter 5 - Item Properties Date & Time Item Subclass Properties
element MON is used twice for a single item, with the following format string:
MON D-MON D
Suppose the data is this:
Feb 28-Mar 31
28 is not validated for the month of February.
Some combinations of reserved words are invalid. A separator must follow
reserved words representing a variable number of digits (D and M for date) if data
follows.
For example:
D/M/CCYY is valid
CCYYM/D is valid
DMCCYY is invalid
See Chapter 8 in the Introduction to the Design Studio for a list of reserve words
and symbols.
Date and Time Format Examples
The following list includes examples of popular standard date and time formats:
Format Description
X12 EDI Currently supports fractional seconds. HH24MM[SS[0-2]]
HL7 The time format in HL7 is HH24MM[SS[.0-6]][+/-ZZZZ]. HL7 also
has a TimeStamp format: CCYYMMDDHHMM[SS[.0-6]][+/-ZZZZ], a
combination of date and time.
SAP SAP represents time as HHMMSS
ODBC The form most commonly used in ODBC mapping is
HH:MM:SS[.0-9]. The fractional part is optional and not often used