i tried your code but i keep getting the error The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. [SQLSTATE 22007] (Error 296) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed