>How can I determine whether a date is DMY or MDY? For instance, if I have a date that is formatted as follows: 01/02/48
>The field in my table is a date of birth field and is a character field. Does anyone have any code written that will tell me whether the 01 is a month or a day. The same goes for the 02 portion of the field.

If somebody's written something in french, or any non English language, you know you are not in MDY right?

Seriously, what you could do if you have a look at the table. If you find the first parameter > 12 then you know it's not a month right?