I altered the date columns wherever it was mentioned varchar to datetime but still no help. Please advise.

Sorry guys for incomplete information. Here is the error that we are getting.

Msg 241, Level 16, State 1, Line 3

Conversion failed when converting datetime from character string.

When i do a...