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