Can I use Export and Import to correct a Field type?

Ask the community
,
1

I have a database containing approx 1500 records. One of the fields is currently defined as type Text. This was a mistake when I loaded the database. The fields in the original CSV file are in format of MM/DD/YYYY. It should have been a Date field.

Can I Fix as follows:

  1. export all fields
  2. change field type from Text to Date
  3. import all data.

Since I am exporting the ID, this should overwrite the database with the same data but in a Date format. Then would I be able to use wix-code to display the field as I wish as well as do “date” calculations…i.e… where exp_date < TODAY.

Thanks
JD

2

NO ONE answered, but FYI. This DID WORK.
JD