Hi!

I have a report that needs to be run on the seventh of every month for
the dates from 6th of the previous months to the 5th of the current
month. For example, I have to run a report on February 7th for the
01/06/2007 to 02/05/2007. Right now I am doing it manually but I was
curious if there a function or something that will give me the
required date range on the 7th of every month.

Any ideas?

Thanks,
T.

tolcis (nytollydba@gmail.com) writes:
> I have a report that needs to be run on the seventh of every month for
> the dates from 6th of the previous months to the 5th of the current
> month. For example, I have to run a report on February 7th for the
> 01/06/2007 to 02/05/2007. Right now I am doing it manually but I was
> curious if there a function or something that will give me the
> required date range on the 7th of every month.

SELECT @today = convert(char(8), getdate(), 112)
IF DAY(@today) = 7
BEGIN
SELECT @startdate = dateadd(DAY, -2, dateadd(MONTH, -1, @today))
SELECT @enddate = dateadd(DAY, -1, @today)
--- Run uery
END

You can learn more about the date functions in Books Online.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx