Date function

[tolcis]

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.

[Erland Sommarskog]

Re: Date function

tolcis (nytollydba@gma il.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@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx