If I take the query shown in SQLProfiler and run it in QueryAnalyzer, I receive the following error;

Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to data type datetime.