Functions are good unfortunately I only have a SQL 2005 at this time so the Date variable type is not available to me.

Thanks for the responses. Mine works as well.