NPeeters,

Can you please elaborate on what is going on in the sample code you post. Especially the part - count(*). What purpose is this serving.

This is how it was done in Access. However, I don't think there is a similar function in T-SQL.

Days in Error: workdays([creation_date],Date())

Thanks