> If you want to return only data older than the last 28-31 days, use '<':
>
> WHERE
> datecreated <
> DATEADD(m,-1,DATEADD(day, 0, DATEDIFF(day, 0, GETDATE()))), GETDATE()

"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:O6AtZ3W2HHA.4680@TK2MSFTNGP03.phx.gbl...
>> Does this part of the query look correct? It's formated so that it
>> doesn't use the time feature and zero's it out to midnight...
>>
>> where datecreated between
>> DATEADD(m,-1,CAST(CONVERT(CHAR(10),GETDATE(),120)as DATETIME)) and
>> GETDATE() order by datecreated
>
> This looks OK to me as long as you want the last 28-31 days or so of data,
> including the current day. However, you might consider using
> DATEADD/DATEDIFF to remove the time portion of datetime:
>
> DATEADD(day, 0, DATEDIFF(day, 0, GETDATE()))
>
>> how would i create a query that returns all the rows with the exception
>> of the past month....? thank you!
>
> If you want to return only data older than the last 28-31 days, use '<':
>
> WHERE
> datecreated <
> DATEADD(m,-1,DATEADD(day, 0, DATEDIFF(day, 0, GETDATE()))), GETDATE()
>
> To return only data older than the start of last month:
>
> WHERE
> datecreated <
> DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0)
>
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
> news:uNJ3P5S2HHA.3640@TK2MSFTNGP06.phx.gbl...
>> Does this part of the query look correct? It's formated so that it
>> doesn't use the time feature and zero's it out to midnight...
>>
>> where datecreated between
>> DATEADD(m,-1,CAST(CONVERT(CHAR(10),GETDATE(),120)as DATETIME)) and
>> GETDATE() order by datecreated
>>
>> how would i create a query that returns all the rows with the exception
>> of the past month....? thank you!
>>
>