Community
Showing results for 
Search instead for 
Do you mean 
Reply

Changing the prporty of a field

Tuned Listener
Posts: 35
Country: Belgium

Changing the prporty of a field

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.

 

Kind regards

 

Jurgen Poelmans

JM
Nickel Contributor
Posts: 584
Country: USA

Re: Changing the prporty of a field

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.

JM

Platinum Elite Contributor
Posts: 14,389
Country: Australia

Re: Changing the prporty of a field

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.