Thanks for all the help.

I figured out that the second error was caused by the declaration of the @wl_status variable. Once I fixed this and then included the date...

Hi All,

I ran the following two statements within the main code as tests and got the following error for both:

Msg 8115, Level 16, State 6, Line 45

Arithmetic overflow error converting...

Hi Chris,

The data is fine. All four date fields in the select statment from the table are datetime data types already, so it shouldn't be a problem. I...