I have a few Mask Edit Boxes in my program with a mask if ##/##/####. I had the column that the msktxtb was binding to set to nvarchar data type but kept receiving error:

String was not recognized as a valid datetime. Couldn't store < / /> in Column. Column is not DateTime data type.

I change the appropriate columns data types to datetime datatypes and now I am receiving this error:

The conversion of a char data type to a datetime data type resulted in an out of range datetime value.


Also my msktxtb do not recongize a single digit date for the day.

Example:

If I input 11/09/2012 into the msktxtb when the cursor moves from the msktxtb date shows as 11/92/012


How do I get the msktxt to recongize the date as 11/09/2012? What is the appropriate data type for ##/##/####?