>>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.
>
>Why the DOB field is a character in your table? And how was it populated? Did it come from your form or from some external data?
>
>You may try to cast to the date field in the select statement in the try/catch block. If select fails, try switching the set date and re-try.

And if it succeeds ? :-}