I am wondering if there is an easy way to change a custom form field already created and in the database that is set as a text / varchar in the database, but I need that form field to now be a date field. Any recommendations? I do not want to re-upload the leads if possible, and I have tried changing the name in the database under field_meta_data but it makes all the info in that field disappear , if I rename it back to varchar it all comes back. So I think I am just missing something. Any help would be great!
You would need to alter the extension vardefs for this field and then alter the type in the the fieldsmetadata and then do a quick repair and rebuild.
Actually perhaps just the field_meta_data and then a quick repair and rebuild.