>>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.
>
>
>Hi,
>
>to determine wether if in 01/02/48 is 1st feb 1948 or 2nd jan 1948 you could add 31 days to 01/02/48 and see which part of 01/02/48 increased. Is that an idea?
>
>Regards,
>
>Koen
But that field is CHAR() so the part that will increase after adding days will be that part that Larry decides to be days :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.