When upgrading to OpenClinica version 3.1, the application will attempt to transform existing data in the item_data table of type DATE or PDATE to match the ISO 8061 format, as discussed below. Transformations will be applied at upgrade time by OpenClinicas Liquibase database change tracking library.

Date values stored in other parts of the database other than the item_data table will not be modified.

5.2.1 DATE Datatype

 

Values collected in prior versions of OpenClinica should be stored in the MM/DD/YYYY format.  If the data is stored in a different format, the values will not be updated and will remain as they are.  A separate script will need to be created to identify and update these values.

For all dates stored in MM/DD/YYYY, a liquibase script will convert the values to conform to the ISO 8601 standard date format, YYYY-MM-DD.

5.2.2 PDATE Datatype (Complete Dates)

 

Values collected in prior versions of OpenClinica should be stored in the MM/DD/YYYY format.  If the data is stored in a different format, the values will not be updated and will remain as they are.  A separate script will need to be created to identify and update these values.

For all partial dates stored in MM/DD/YYYY, a liquibase script will convert the values to conform to the ISO 8601 standard date format, YYYY-MM-DD.

5.2.3 PDATE Datatype (Month and Year Provided)

 

Values collected in prior version of OpenClinica would be stored in the format specified by the users locale.  The default format in the user interface for DATE and PDATE in OpenClinica is DD-MMM-YYYY.  The default format in the user interface for DATE and PDATE in OpenClinica is DD-MMM-YYYY.  Therefore, when only a month and year are provided in a PDATE field, the value in the database would be MMM-YYYY.  This is the only format that will be updated automatically by a liquibase script when OpenClinica is upgraded to Amethyst.  A separate script will need to be created to identify and update values in a different format.

For all partial dates stored in MMM-YYYY format, the liquibase script will convert the values YYYY-MM in order to conform to the ISO 8601 standard date format.

5.2.4 PDATE Datatype (Year Provided)

 

No changes will be made.  The values saved in prior versions of OpenClinica (in the format YYYY) meet the ISO 8601 standard date format.