There's nothing you can do. How would you or program know what date '3/6/2000' represents. Is it March 6th or June 3rd of 2000?

>I'm importing data from an excel worksheet and the date fields have mixed format, for example some records have a month-day-year format and others have the day-month-year format. How can I import these records into a foxpro database with only one date format? I'd really appreciate somebody can help me with this one.
>
>TIA,
>
>Enmanuel