0

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.

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.

1 reply

null
    • Simon.1
    • 3 yrs ago
    • Reported - view

    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.

Login to reply

Content aside

  • 3 yrs agoLast active
  • 1Replies
  • 453Views