Hi, i have a date variable that i take on a form. it is for a birthday. so the variable is birthday, yyyy, mm, dd set in a varchar field. i was using createodbcdatetime to get it into a "datetime" format... but MS SQL isn't letting me insert this value into the regular datetime datatype. How do i need to convert the original string into the datetime, preferably smalldatetime, so that it will be accepted by MS SQL? thanks! (im googling too)