IM Relationship Resolution Information Center, Version 4.2

DQM function 204: Date validation and format

DQM function 204 validates the date and time format of the value of the UMF tag.

The function applies an output format of YYYY/MM/DD or YYYY-MM-DD, depending upon the system date delimiter. The system date delimiter "-" or "/" are determined by configuration requirements. If Output time component with dates? (Y/N) of this is set to "Y", a time component in the format of HH:mm:SS is expected in the input date.

If you configure the DQM rule to correct the data, and the date is invalid or is not able to be properly formatted, the function removes the value from the UMF tag. If the correction procedure is not configured to correct an error, the function logs an exception to the configured error log and the value will or will not be loaded according to the exception severity.

Function parameters

Output time component with dates? (Y/N)
Include time component with date value of the UMF tag. If this parameter is set to Y, and no time value exists in the input value, a time value of 00:00:00 will be added to the output value. (DEFAULT = N)
User-Specified Date Format n
User defined date formats. If configured, contains a supported input date format, for the current UMF segment. If no other parameters are configured, the only input date formats accepted by the validation process are “YYYY/MM/DD” or “YYYY-MM-DD”. If Output time component with dates? (Y/N) is set to Y, any User-Specified Date Format n parameters will include the addition of both HH:mm and HH:mm:SS time formats for validation.
Supported User-Specified Date Format n date mask characters:
  • DD for two digit day
  • MM for two digit month
  • YY for two digit year
  • YYYY for four digit year
  • - for date delimiter
  • / for date delimiter
Supported 8 digit user defined input date formats:
  • YYYYMMDD
  • MMDDYYYY
  • DDMMYYYY
  • MM/DD/YYYY
  • MM-DD-YYYY
  • DD/MM/YYYY
  • DD-MM-YYYY
Supported 6 digit user defined input date formats:
  • MM/DD/YY
  • MM-DD-YY
  • YY/MM/DD
  • YY-MM-DD
  • DD/MM/YY
  • DD-MM-YY
  • YYMMDD
  • MMDDYY
  • DDMMYY
  • YYYY/MM
  • YYYY-MM
  • YYYYMM
  • MM/YYYY
  • MM-YYYY
  • MMYYYY
Supported 4 digit user defined input date formats:
  • MM/YY
  • MM-YY
  • MMYY
  • YY/MM
  • YY-MM
  • YYMM
  • YYYY
Incoming dates are first validated using the default date formats “YYYY/MM/DD” or .YYYY-MM-DD. If configured, the User-Specified Date Format n values are validated in the order they are recorded. If you use conflicting date formats, this may result in the validation of dates that may be correctly or incorrectly ambiguous. For example, using the User-Specified Date Format n parameter, if you configure an eight digit date MM-DD-YYYY followed by a conflicting eight digit date DD-MM-YYYY, and the date value 12-02-2004 is passed through, the following occurs:
  • The date value (12-02-2004) is compared to the first User-Specified Date Format n parameter MM-DD-YYYY.
  • According to the parameter, the date value is considered valid.
  • A date of December 2, 2004 is recorded.
Even if the date should have been February 12, 2004, because 12-02-2004 satisfies the 1st Second (+) parameter, that is the parameter used to define the date.

Exception codes

Exception Code Description Severity*
-2 Unsupported input format. 3
-1 The value of the UMF tag is not a valid date (Correction Procedure not configured). 3
1 The value of the UMF tag has been validated. 0
2 The value of the UMF tag has been validated and reformatted (all components included on input – reformatted to be in valid output format – nothing added or removed. 0
3 The value of the UMF tag is empty. 1
4 The time component from the value of the UMF tag has been removed. 3
5 The value of the UMF tag value modified to create a valid date (input date has missing components). 0
6 Correction Procedure configured. The value of the UMF tag was invalid and corrected by blanking out the value. 1
7 The value of the UMF tag was modified by completing date and removing time component. 3


Feedback

Last updated: 2009