08-11-2008 02:19 AM
Is it possible to change the type of field without loosing the data. We made a field in the past as text, the only thing we put into the field is a date. So now we want to change this field to a date field with no lost of data.
08-13-2008 09:01 PM
Sugestion. Open ACT Demo DB create copy Save Copy As than create a Text Field insert the data in the same format your did in other DB next chnage the field type to a date format to see how it looks. It will not delete data, but the format of data may change. Use this Demo DB for other questions you may have to help reduce your wait time on quesitons like this or to trouble shoot errors by seeing if your source DB is corrupt.
08-23-2008 12:19 AM
I haven't tried this, but it might work...
Create a new date field, use Edit | Copy, to move the text data across and then look at the two fields in the Contact List to make sure it's all ok before deleting the old field.