I have a field that was previously not being used as a real date field but now needs to be a type date. When we changed the data type of the field, type() returns D but it doesn't order like a date and SQL querys on that field are unpredictable for the records that were originally entered as type C. Any way to fix the old records to be a real date?