Posted by AlterEgo on 01/17/07 23:42

tolcis,

There might be a more elegant way, but this should work:

declare @Now datetime
declare @StartDate datetime
declare @EndDate datetime

set @Now = getdate()
if datepart(d, @Now) = 1 -- only execute if it is the first day of the month
begin
-- to get start date, subtract one month from the date and remove the
time from the date
set @StartDate = convert(varchar(15), dateadd (m, -1, @now), 112)
-- to get end date, remove time from date
set @EndDate = dateadd(m, 1, @StartDate)
print cast(@StartDate as char(25)) + cast(@EndDate as char(25))
-- execute your code here using >= @StartDate and < @EndDate
end

-- Bill

"tolcis" <nytollydba@gmail.com> wrote in message
news:1169073028.098703.235980@11g2000cwr.googlegroups.com...
> Hi!
>
> I have a query that has to return bunch of data based on the calendar
> month. I have to make sure that it will return data to me for 28 days
> if it is February and for 31 if it is August(for example). I need to
> be able to execute it every first of every month for the past 30, 31 or
> 28 days based on the calendar month. Is there a function or a stored
> procedure that I can use to do that?
>
> Thank you,
> T.
>

[Back to original message]