>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.
Probably only by examining the entire table (and assuming it is consistent):
SELECT MAX(VAL(LEFT(DATE,2))) FROM Test
If it's > 12 then it's day first. If it's not then check the central characters. But if that's not > 12 then the result is indeterminate.....