@ChrisG Thanks for updating the query.The query did not word for me because of a missing comma.MinimumUsageDate = DATEADD(m, -(st.UsagePeriod * 30), GETDATE())should be MinimumUsageDate = DATEADD(m, -(st.UsagePeriod * 30), GETDATE()), Just in case so...