I've got a form which has a DOB field (textbox) ...my potential problem is that when a user does not supply the correct format i'm having a problem saving the data. For example...
If the user supplies '1/1/91' i'm getting an out of range error since the stored proc which does the saving of data
CONVERT(DATETIME, @DOB, 121) as DOB
Is there any way of saving the data without experiencing the errors.