Date and time validation

The Oracle InForm Data Import utility performs the following validation checks for datetime data:

Validation check	Description
DISPLAY attribute of CRF datetime control.	The MedML DISPLAY attribute must be set to True for the components of the CRF datetime control into which a date, time, or datetime item is being imported. The Oracle InForm Data Import utility ignores date and time components for which the DISPLAY attribute is False, and it does not import them.
Year value of import field.	If the imported year is outside the range allowed in the CRF datetime control, the Oracle InForm Data Import utility issues an error.
Day value of import field.	If the Year and Month values are valid, the Oracle InForm Data Import utility checks for a valid day value.
REQUIRED attribute of CRF datetime control.	If any datetime component is coded as REQUIRED in the CRF datetime control and is missing in the import file, the Oracle InForm Data Import utility issues an error.
UNKNOWN attribute of CRF datetime control.	If an imported datetime component is coded UNK, but the UNKNOWN attribute of the CRF datetime control is not enabled, the Oracle InForm Data Import utility issues an error.
Consistency checking.	If consistency checking is enabled in the CRF datetime control, the Oracle InForm Data Import utility issues an error if a datetime component is present in the import file without a higher component, or an UNK value, in the following sequence: ss:mm:hh dd/mm/yy For example, if the imported datetime includes a Day field without a Month, the Oracle InForm Data Import utility issues an error.
Hour and Minute values of import field.	The values for both Hour and Minute must be within valid ranges or coded as UNK.