Thank you Krystian, I'm testing out your script. When no queries are running it completes successfully, when I kick off a test query and then run it I get this:

Msg 241, Level 16, State 1, Procedure sp_DetectLongRunningTransactions, Line 48

Conversion failed when converting date and/or time from character string.