>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.
If it's not broken, fix it until it is.
My Blog