I've just imported our company date (14 years of sales and customers) and I used the default "field type" settings. Now I realize that some of the field types need to be changed, for example one field was a date field imported as text but should be a date field. Thanks.

Ninox Profile

I've just imported our company date (14 years of sales and customers) and I used the default "field type" settings. Now I realize that some of the field types need to be changed, for example one field was a date field imported as text but should be a date field. Thanks.

Ninox Profile

Hi Ron – if you create the correct fields (in your example a Date field) then you can copy the data from the (text)date field to the new Date field using "Update multiple records. Chose "Assign calcuated  value" in the drop down menu and type the 'wrong' date field in.

Reply