Here's one I just wrote myself

[Duncan Edwards Jones]

SELECT DATEADD(dd,DATEDIFF(dd,GETDATE(),@rundate),GETDATE()) - [ProcessSchedule].[LastRunTime] As [Difference]

So - intention is wonderfully opaque there then.

[raddevus]

How long has it been since it last ran? :~ Am I the unofficial winner of an official no-prize? :laugh:

[Duncan Edwards Jones]

Would the task have been overdue if we were at the current time on the date at which the task was due. A very bad piece of code for a very bad business need.

[megaadam]

Nice to see that DD still has a foothold in programming, despite his venture into politics.

... such stuff as dreams are made on