471,066 Members | 1,270 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

Date function

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.

Feb 7 '07 #1
1 4418
tolcis (ny********@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, es****@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
Feb 7 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by androtech | last post: by
30 posts views Thread by Dr John Stockton | last post: by
1 post views Thread by Liz Malcolm | last post: by
10 posts views Thread by John Morgan | last post: by
12 posts views Thread by Assimalyst | last post: by
3 posts views Thread by dave | last post: by
10 posts views Thread by Jes | last post: by
3 posts views Thread by murch.alexander | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.