it is sort of a new question. In order to implement the function that I was given below, I need to determine the month for which the data is being returned. Because it is a moving timeframe, the best way to do this would be to get the name of the month from the date field? Is there such a function in VBScrip or ASP that takes a date (ex: 3/1/84) and returns the month (ex: "March" or "Mar")??