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.