change this

WHERE (dbo.RECORDED_SERVICE.STARTTIME < { fn NOW() } - 80)

to

WHERE (dbo.RECORDED_SERVICE.STARTTIME < DATEADD(day,-80, GetDATE())

Be aware this will not affect the time.