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.
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 |