Hello all. I have a text - multiple choice field that represents a date in the format yymmdd (i.e.161129 for November 29th, 2016). I'd like to convert this text field to a date field. When I change the field type to a date, all exiting values change to 01-01-1970. I've tried creating a date formula field using the MID function to parse the values in the text field and put it in mm-dd-yyyy format and then ToDate to convert it to a date value. However, once on my form, the dateforumla field is not editable. I then used a form rule to move the dateformula field values into a new date field. However, that form rule only executes when the form is opened in edit/add mode. What is the best way to convert the existing text values into a date field that is editable on a form?