Posted by AlterEgo on 01/18/07 00:25

Roy,

Wya cool, did not know this!

-- Bill

"Roy Harvey" <roy_harvey@snet.net> wrote in message
news:vietq2l4344pq52plgrnael566amuu5pfb@4ax.com...
> WHERE create_date < DATEADD(month,DATEDIFF(month, 0,getdate()),0)
> AND create_date >= DATEADD(month,DATEDIFF(month, 0,getdate())-1,0)
>
> Roy Harvey
> Beacon Falls, CT
>
> On 17 Jan 2007 14:30:29 -0800, "tolcis" <nytollydba@gmail.com> wrote:
>
>>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.

• Next in forum: urgent!!!!! what is the escape sequence for double quotes--microsoft sql query???
• Prev in forum: Re: linking tables from other databases?
• Thread view: Re: Job to be run ever first for the previous calendar month

[Reply to this message]