Hi Everyone thanks for the replies.

For the first 2, I'm not using static dates as per your queries.

Scott, your query is just casting values for actual field values. OPENDATE and ASSGNDATE are actual fields in a task table. When I run that query I get 3 returned records based solely on the SELECT GETDATE.

The output is based on the current time:

ASSNDATE OPENDATE Date_Diff

2014-05-05 09:29:30.8332014-05-05 09:38:30.8330:09

2014-05-05 06:22:30.8332014-05-05 09:38:30.8333:16

2014-05-04 07:46:30.8332014-05-05 09:38:30.83325:52

I need to do this on every record in the table (minus anything that's not being worked on). Suggestions?