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.
_________________________________________________________________________
SSC Guide to Posting and Best Practices