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?
CA Harvest SCM v12.x and up
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.