>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.
That is one of the reasons to store data in proper field types.
If you store it in Date/Datetime field you wouldn't have such problem.
Your only hope is to check all other data and see if you can understand what is month and what is day.
BTW 01/02/10 is 1910 or 2010?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.