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

The Error Occurs when the input is date and the given day values are not in the range of the expected days for a given month(1-31)

For eg.

You cannot specify the date parameter as Feb 31 2009 since february only has 28 days in a non-Leap year and it throws the above error.

Leave a Reply