Not sure about this...wondering if a looping script with Set Variable, SetField would trigger the entry to the format desired. Looping 200K records for a single field adjust wouldn't take too long.
Give it a try.
If not, reimport ought to work too.
Surely there's a better way, but when brute force only takes a couple of minutes, why look for elegant?
Even simpler than a looping script would be replace field contents, but are you sure that your field is of type date?
Yes, I'm positive it is of date type, double checked that. I thought about replace field contents but I wasn't sure how to format it, especially since the dates are all so random. Would I have to do a search for each specific date and change them and then go through the entire list? Or is there a way to do it with a calculated result?
The idea for using replace field contents is to avoid needing a loop or any record specific special handling. But if the data in the field is of type date, it should correctly display the desired format simply by changing the data format options for the field in the Inspector.
If you still find that this does not work, you might try this:
Show all records
Put the cursor in the date field and select replace field contents.
Select the Calcualtion option and see if this expression fixes the issue:
GetAsDate ( GetAstext ( YourTable::YourdateFieldHere ) )