Changing large amounts of data
I have a database with over 200,000 records in it. I imported these records, and there is a date column that uses this format: YYYY-MM-DD. Filemaker has not recognized this format as a date; therefore, I have been unable to sort out the dates that I dont want to view.
How can I change the column or get Filemaker to recognize this format?