IM Relationship Resolution Information Center, Version 4.2

Deprecated: DQM function 205: date validation and format

This function validates that the UMF tag's value is a valid date and formats the date according to one of the available date formats.

Each format choice is dependent on which database platform is used.

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 does not load the invalid value.

Parameters

Date Format:
The platform specific formatting directive.
ORACLE
(Default) - implies "YYYY/MM/DD" format
ORACLE DATETIME
implies "YYYY/MM/DD HH:MM:SS" format
ISO DATE
implies "YYYY-MM-DD" format
ISO DATETIME
implies "YYYY-MM-DD HH:MM:SS" format
Fill in missing date parts?:
Determines if incomplete date values are valid. Incomplete date values are dates that must be extended to be considered valid dates prior to date formatting.
For example: 01/1965 would be changed to 01/01/1965 to be considered valid. 00/00/2004 and 2004 would be changed to 01/01/2004 to be considered valid.
Y
Fill in missing date parts.
N
Do not fill in missing date parts.

Exception codes

Exception Code Description Severity*
-3 First parameter contains invalid option. 3
-2 Unable to correctly format the date value. 3
-1 The value of the UMF tag is not a valid date. 3
1 Invalid date value was removed from UMF tag value. 0
2 The value of the UMF tag has been properly formatted. 2
3 The value of the UMF tag is empty. 1
4 The value of the UMF tag was extended to create a valid date. 0


Feedback

Last updated: 2009