Posted by tolcis on 02/07/07 20:44

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.

• Next in forum: Re: Dynamic SQL does not work!
• Prev in forum: Re: "insert on existing update" in MS SQL Server?
• Thread view: Date function

[Reply to this message]