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:
- export all fields
- change field type from Text to Date
- 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