yup

right. Doing this project someone else has done is just complete.....lets not go there.

When the user enters a date time in the format of:

dd/mm/yyyy

SQL will complain that it cannot convert char to datetime or something and that the value given exceeds the sql datetime limit. I am guessing it is expecting mm/dd/yyyy

what is the best way to tackle this? Would I need to "switch" around the dd and mm?