Where between

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

coady - 29 May 2008 18:56 GMT

Hi,

I am trying to run a report that would only grab the data after, for
example, May 1st from column 2.

So far my query looks like this:
select column 1, column2
from dbo.table1

How do I tell it to just grab the data after May 1 2008? Is it something like
WHERE ([Time] BETWEEN DATEADD([day], -1, GETDATE()) AND GETDATE()) ?

Thanks in advance.

Reply to this Message

LVP - 30 May 2008 00:04 GMT

Where column2 > '5/1/2008'

> Hi,
>
[quoted text clipped - 10 lines]
>
> Thanks in advance.

Reply to this Message

coady - 30 May 2008 00:27 GMT

Thank you for the reply.

Sorry I didn't mention that the column 2 format is (smalldatetime, null)

> Where column2 > '5/1/2008'
>
[quoted text clipped - 12 lines]
> >
> > Thanks in advance.

Reply to this Message

LVP - 30 May 2008 00:39 GMT

and Column2 is not null

Not sure what you said.

> Thank you for the reply.
>
[quoted text clipped - 17 lines]
>> >
>> > Thanks in advance.

Reply to this Message

coady - 30 May 2008 00:49 GMT

It's smalldatetime.

Thank you again.

> and Column2 is not null
>
[quoted text clipped - 21 lines]
> >> >
> >> > Thanks in advance.

Reply to this Message