Need to change a form text field to date field

Document ID : KB000120684
Last Modified Date : 13/12/2018
Show Technical Document Details
Introduction:
We have a custom form that has a text field named "Build Due Date" that we want to change so that Harvest handles it as a date field rather than text. How can this be done?
Environment:
CA Harvest SCM v12.x and up
Instructions:
Since the original field was text and the new field is to be a date, it is not possible to just change the field on the form.  You will need to add a new field of the correct data type.

1. Write and execute an SQL script to add a row to the HARFORMTYPEDEFS table for the new field, and alter the form's data table to add a new column.  
2. Update the form's xml file to insert the new field in the desired place and with the desired label for the field.